Update Top N rows in sql server 2005




SQL Server 2005 enables us to update specific number of top rows in our table. Its completely a new feature added in sql server 2005



-- USING TOP(N) WITH UPDATE OPERATION
UPDATE TOP(3) tablename SET NAMES='HCL'



Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: