--测试代码
exec sp_executesql N'SELECT 
    [Extent1].[use_UpdatePosDayAfter] AS [use_UpdatePosDayAfter], 
    [Extent1].[use_id] AS [use_id], 
    [Extent1].[use_level] AS [use_level], 
    [Extent1].[use_name] AS [use_name], 
    [Extent1].[emp_id] AS [emp_id], 
    [Extent2].[emp_name] AS [emp_name], 
    [Extent2].[dpt_id2] AS [dpt_id2], 
    [Extent2].[pst_id] AS [pst_id], 
    [Extent1].[use_pws] AS [use_pws], 
    [Extent1].[use_shp] AS [use_shp], 
    [Extent1].[use_UpdatePosDay] AS [use_UpdatePosDay], 
    [Extent1].[sys_valid] AS [sys_valid]
    FROM  [dbo].[BAS_USER] AS [Extent1]
    LEFT OUTER JOIN [dbo].[BAS_EMP] AS [Extent2] ON [Extent1].[emp_id] = [Extent2].[emp_id]
    WHERE (((UPPER(LTRIM(RTRIM([Extent1].[use_id])))) = (UPPER(LTRIM(RTRIM(@p__linq__0))))) OR ((UPPER(LTRIM(RTRIM([Extent1].[use_id]))) IS NULL) AND (UPPER(LTRIM(RTRIM(@p__linq__0))) IS NULL))) AND ((CASE WHEN (1 = @p__linq__1) THEN CASE WHEN (1 = [Extent1].[sys_valid]) THEN cast(1 as bit) WHEN (1 <> [Extent1].[sys_valid]) THEN cast(0 as bit) END ELSE cast(1 as bit) END) = 1)',N'@p__linq__0 nvarchar(4000),@p__linq__1 bit',@p__linq__0=N'hbd',@p__linq__1=1

ALTER TABLE BAS_USER ADD use_UpdatePosDayAfter [int] NOT NULL

update BAS_USER set use_UpdatePosDayAfter=0

	ALTER TABLE BAS_USER ADD use_UpdatePosDayAfter [int] NOT NULL

	update   BAS_USER set use_UpdatePosDayAfter=0


	ALTER TABLE dat_ckfc ADD  [wg_dhd_id_new] [nvarchar](50) NULL
	
	ALTER TABLE dat_ckpf ADD  [wg_dhd_id_new] [nvarchar](50) NULL
		ALTER TABLE dat_ckpt ADD  [wg_dhd_id_new] [nvarchar](50) NULL