SQL Server 根据动态条件insert,update语句

1.Insert - 新表newTable不存在

select 1 as id,column1 as column1 into newTable from oldTable where column2='column2'

2.Insert - 新表newTable存在

insert into newTable(id,column1) select 1 as id,column1 as column1 from oldTable where column2='column2'

insert into newTable(id,column1,column3)

  select 1 as id,column1 as column1,

  (select column3 from temp where column4='column4') as column3 

  from oldTable where column2='column2'

 3.Update - 两个表名必须不一样，所以same db in different instance不能直接这样做

      UPDATE drivestorage SET drivestorage.设备名称=facilityNum.设备名称 FROM facilityNum WHERE drivestorage.设备号=facilityNum.设备号

转载于:https://www.cnblogs.com/sui84/archive/2013/04/07/6777221.html