... @myValue INT OUTPUT -- this is the output parameter -- next operation is atomic UPDATE dbo.myTable SET column1=column1+1,@myValue=column1+1 WHERE selectTheRow