General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
I want to lock a row in a table.
I want to create an stored procedure for this task
This table holds correlatives numbers and this what i want to do
1.) Lock the row
2.) Increment the correlative numer, Column1 = Column1 + 1
3.) Assign the number to an output parameter.
4.) Unlock the row
This will prevent duplicating a correlative number.
Can someone help me please.
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