Explore Update() function to stop this behavior. Refer the link below:
http://msdn.microsoft.com/en-us/library/ms187326.aspx
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter