oracle has for update concept is there
in same way is there same concept in SQL server 2005
Please give example