select from [dbo].[Config_Device_All] order by CreateTime desc
    delete [dbo].[Config_Device_All] where GUID not in(‘c960b0e7-a498-48f0-97c3-7c81a49b943d’)
    select     from Data_Project_Info where GUID = ‘d25815a7-8ddc-474f-a48e-de1f381c21f6’

    复制原表到新表
    select * into [OsCalibration].[dbo].[FreqResp_CH4] from [OsCalibration].[dbo].[FreqResp_CH1]

    删除列
    alter tableName add “ColumnName” varchar(50);
    增加列
    alter tableName drop “ColumnName”