How to use direct update query over Identity column in SQL server. --According to is behavior we can't update
--Aslo we can't use identity_insert, fired for insert
--lets try a altration over column, difffffuuasdasdasdasdkldnas again not possible
--unable to found any syntex to do it. alternative solution is to make copy of all data in to other and then drop/recreate.
either column or complete table drop/recreate.
But there always be a hole for rat :-++))) ahhhhaa
Tags: How to use direct update query over Identity column in SQL server