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