Please mark as helpful and propose as answer if you find this as correct!!! Thanks, Rakesh.
if you are updating just two column you can do it by update command simply as you said id column is identity then you can write update command as below
UPDate test_table set col1 = 'a', col2 = 'b' where id<=10000
Efficiently in which way? Performance, required log file size or ... ?
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?