SET ROWCOUNT () in SQL SERVER2008

CGN007
Posted by CGN007 under Sql Server category on | Points: 40 | Views : 1736
SET ROWCOUNT 2;
UPDATE EmployeeMas
SET sal = 400
WHERE sal >3000;


Set ROWCOUNT to 2 and update all rows with sal>3000

Comments or Responses

Login to post response