Using Update and Top in Sql server 2008

Sql Server 2008′s new TOP statement could help update the Table in batches

Consider the following Example

Update

Update

The above code illustrates how the batchUpdate can be done using Top().

The top 100 records are updated depending on the criteria where fullname is null so that the same records dont get updated again

Posted April 2, 2009 by Vivek. Comments and trackbacks are open. Follow the comments feed.
Filed under:
Tagged with: .

Leave a Reply

←
→