Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lock row
Message
From
20/03/2004 12:34:49
 
 
To
20/03/2004 11:14:14
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Miscellaneous
Thread ID:
00888209
Message ID:
00888223
Views:
10
... @myValue INT OUTPUT -- this is the output parameter
-- next operation is atomic
UPDATE dbo.myTable SET column1=column1+1,@myValue=column1+1 WHERE selectTheRow
But, if it is a id, then you can do the operation with a identity and @@IDENTITY.

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform