--I_GBGradeIDSELECT  *FROM    T_NPick_PkgMovWHERE   I_GBGradeID NOT IN ( SELECT I_GBGradeID                             FROM   T_GBGradeCode )                             DELETE  FROM T_NPick_PkgMovWHERE   I_GBGradeID NOT IN ( SELECT I_GBGradeID                             FROM   T_GBGradeCode )      --V_CustomerIDSELECT  *FROM    T_NPick_PkgMovWHERE   V_CustomerID NOT IN ( SELECT    C_CustCode                              FROM      T_CustomInfo )                                    ALTER TABLE T_NPick_PkgMov ALTER COLUMN V_CustomerID VARCHAR(5) NOT NULL   --新增业务日期BusinessDate字段ALTER TABLE T_NPick_PkgMov ADD BusinessDate INT NULL--将datetime转为intUPDATE  T_NPick_PkgMovSET     BusinessDate = CAST(REPLACE(CONVERT(CHAR(10), D_Time, 120), ‘-‘, ‘‘) AS INT)