如题,我创建了一个存储过程,使用的是动态语句,具体如下:createprocedurebaobiao1@date1datetime,date2datetimeassetnocountonbeginSetXACT_ABORTON;BeginTranDeclare@SQL1varchar...
如题,我创建了一个存储过程,使用的是动态语句,具体如下:
create procedure baobiao1 @date1 datetime ,date2 datetime as
set nocount on
begin
Set XACT_ABORT ON;
Begin Tran
Declare @SQL1 varchar(8000)
Declare @SQL2 varchar(8000)
--Set @SQL='Create view A as select ....'
--Exec(@SQL)
if exists (SELECT * FROM sysobjects WHERE name = 'report1')
drop view report1
set @SQL1='create view report1 as select s.englishName,s.belongzu,count(*) kaitai,
jiachan=(case s.shiftName when ''甲'' then sum(s.realproduc) else 0 end),
jiachaochan=(case s.shiftName when ''甲'