Tuesday 5 May 2020

how can I Update top 100 records in sql server

https://stackoverflow.com/questions/1198364/how-can-i-update-top-100-records-in-sql-server

Note, the parentheses are required for UPDATE statements:
update top (100) table1 set field1 = 1

No comments:

Post a Comment

Note: only a member of this blog may post a comment.

Blog Archive