Thursday, May 7, 2009

Updating top n records

Sometimes we need to update top n records, try using following synatax:
update top (5) [aspnet_Membership] set IsLockedOut =1

No comments: