sql

批量更新
表2数据批量更新到表1数据
UPDATE Table1 SET Table1.NumA = Table2.NumB Table1.TotalA = Table2.TotalB FROM Table2 WHERE Table2.ID=Table1.ID
批量插入
表2数据批量插入表1
INSERT INTO Table1(NumA,TotalA) SELECT NumA,ToTalA from Table2 where ID > 5
设置表列为非空
alter table packet alter column inner_unit nvarchar(256) null
表添加列
alter table packet add column inner_unit nvarchar(256) null