A UPDATE statement in SQLServer

xiaoxiao2021-03-05  26

Use a table Update to another table according to conditions

Update table1 set id = t2.id from table1 T1, table t2 where t1.name = t2.name

Create a new table according to existing content

Select ID, Name Into nextTable from Oldtable where ...........

转载请注明原文地址:https://www.9cbs.com/read-35384.html

New Post(0)