How to get updated row's PK_ID

How to get updated row's PK_ID

UPDATE 
    [M_RATINGS] 
SET 
    [RATING] = @rating 
WHERE 
    [POST_ID] = @postId AND 
    [U开发者_如何转开发SER_ID] = @userId; 

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;