sql 测试脚本 wellcare

declare @DATE VARCHAR(10)
	set @DATE='2013-03-19'
declare @PackageName varchar(50)
	set @PackageName='WellCare_Servicefund'
--'WellCare_Servicefund'
--'WELLCARE_SPECIALITY_CAPITATION'
-- 'WELLCARE_MEMBER_DEMO'
-- 'WELLCARE_PHARMACY'

declare @testKind int
	set @testKind=0 -- 0:select; 1:delete
declare @sql varchar(max)
	set @sql=''

if(@testKind=0)
begin
	set @sql='
	SELECT TOP 10  *
	FROM [EDW_PreSource].[dbo].[' + @PackageName + ']
	where convert(varchar(10),DW_insert_DATE,120)=''' + @DATE + '''
	order by DW_insert_DATE desc
   
	select top 10 * 
	from SqlLogging..FileMetrics
	where PackageName=''' + @PackageName + '''
	AND convert(varchar(10),ImportDate,120)=''' + @DATE + '''
	order by ImportDate desc'   
end
else if(@testKind=1) 
begin
	set @sql='
	delete
	FROM [EDW_PreSource].[dbo].[' + @PackageName + ']
	where convert(varchar(10),DW_insert_DATE,120)=''' + @DATE + '''

	delete
	from SqlLogging..FileMetrics
	where PackageName=''' + @PackageName + '''
	AND convert(varchar(10),ImportDate,120)=''' + @DATE + ''''
end

--PRINT @SQL
EXEC(@SQL)