I am creating a stored procedure and need to increment a system file field (counter) and not sure if I am doing it correctly. This is what I have within my procedure:

....

UPDATE [dbo].[Sys1] Set
@Trno2 = [TRNO2], [TRNO2] = [TRNO2] + 1;

...

I am assigning the variable @Trno2 to Sys1.Trno2 then increment that counter. I will use this variable to save to a newly create record. In a multi-user environment I just want to be sure no one else has incremented the field while this is taking place.