How to get updated row's PK_ID

Question

How to get updated row's PK_ID

UPDATE 
    [M_RATINGS] 
SET 
    [RATING] = @rating 
WHERE 
    [POST_ID] = @postId AND 
    [USER_ID] = @userId; 

Answer 1

Use OUTPUT clause http://msdn.microsoft.com/en-us/library/ms177564.aspx

DECLARE @MyTableVar table(
ID int NOT NULL
); 

UPDATE 
   [M_RATINGS] 
SET   
   [RATING] = @rating 
OUTPUT INSERTED.YourPK_ID INTO @MyTableVar
WHERE 
   [POST_ID] = @postId AND 
   [USER_ID] = @userId; 

SELECT * from @MyTableVar;

Answer 2

Hello All, I may be missing something, but this is not working in my place. While executing this query it gives me a error message like "Incorrect syntax near 'OUTPUT'". Please help me out. Thanks in advance.