Hi

Here are what is new in SQL 2012 with wonderful summary at :

http://www.tsqladmin.com/forum/database/forumlist.asp?forum_id=10848&TopicCode=database

Thanks

Hi

Visit this site :

You could find how to do it in easy way

Mnaouar Ben Khelifa

Thanks

Hi

You could update on driven table but in other way,

You were trying :

Update T SET Id=0 FROM (SELECT * FROM tt1) AS T

but you could use this as follow ,...