SQLSERVER相关修改记录

1.创建索引执行语句：
CREATE NONCLUSTERED INDEX idx_iot_senddate ON Tabel1(表名) (IOT_TerminalNo,SendDate);

2.同步修改字段值

UPDATE t1
SET t1.Wps_ID = t2.Wps_ID
FROM Project_Technology t1
INNER JOIN Project_Technology_Welding t2 ON t1.MGuID = t2.MGuID
WHERE t1.Status =0 and t1.MGUID = t2.MGUID;

3.sql表新增字段
alter table File_Project_Test add [Synch] int DEFAULT ((1)) NULL;