General information
Forum:
Microsoft SQL Server
Hi Michael,
Then how is the nnid returned to the user?
Glenn (SQLServewr newbie)
>There's a cleaner way. You can use UPDATE to increment and fetch the value without have to explicitly manage the locks:
>
>UPDATE id
>SET @nnid = idval, idval = idval + 1
>WHERE keyname = @tcKeyWord
>
>-Mike
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only