该怎样写参数

Question

declare @ytd int 
set @ytd= 'select' + isnull([Mtd201201],0.0) + 
isnull (Mtd201202,0.0) + 
isnull(Mtd201203,0.0) + 
isnull(Mtd201204,0.0) + 
isnull(Mtd201205,0.0) + 
isnull(Mtd201206,0.0) + 
isnull(Mtd201207,0.0) + 
isnull(Mtd201208,0.0) + 
isnull(Mtd201209,0.0) + 
isnull(Mtd201210,0.0) + 
isnull(Mtd201211,0.0) + 
isnull(Mtd201212,0.0) +' from dbo.RPT_resultA41  where companyid=1 and classify=1'
print @ytd

Answer 1

declare @ytd int 
set @ytd= 'select  isnull([Mtd201201],0.0) + 
isnull (Mtd201202,0.0) + 
isnull(Mtd201203,0.0) + 
isnull(Mtd201204,0.0) + 
isnull(Mtd201205,0.0) + 
isnull(Mtd201206,0.0) + 
isnull(Mtd201207,0.0) + 
isnull(Mtd201208,0.0) + 
isnull(Mtd201209,0.0) + 
isnull(Mtd201210,0.0) + 
isnull(Mtd201211,0.0) + 
isnull(Mtd201212,0.0)'+'from dbo.RPT_resultA41  where companyid=1 and classify=1'
print @ytd

Answer 2

这样不行呢!@YTD money才对

Answer 3

declare @ytd int 
set @ytd= 'select  isnull([Mtd201201],0.0) + 
isnull (Mtd201202,0.0) + 
isnull(Mtd201203,0.0) + 
isnull(Mtd201204,0.0) + 
isnull(Mtd201205,0.0) + 
isnull(Mtd201206,0.0) + 
isnull(Mtd201207,0.0) + 
isnull(Mtd201208,0.0) + 
isnull(Mtd201209,0.0) + 
isnull(Mtd201210,0.0) + 
isnull(Mtd201211,0.0) + 
isnull(Mtd201212,0.0) '+'from dbo.RPT_resultA41  where companyid=1 and classify=1'
exec(@ytd)

Answer 4

终于明白了：
declare @ytd int 
select @ytd=isnull([Mtd201201],0.0) + 
isnull (Mtd201202,0.0) + 
isnull(Mtd201203,0.0) + 
isnull(Mtd201204,0.0) + 
isnull(Mtd201205,0.0) + 
isnull(Mtd201206,0.0) + 
isnull(Mtd201207,0.0) + 
isnull(Mtd201208,0.0) + 
isnull(Mtd201209,0.0) + 
isnull(Mtd201210,0.0) + 
isnull(Mtd201211,0.0) + 
isnull(Mtd201212,0.0) from dbo.RPT_resultA41  where companyid=1 and classify=1
print @ytd

Answer 5

declare @ytd int  
set @ytd=(select isnull([Mtd201201],0.0) +  
isnull (Mtd201202,0.0) +  
isnull(Mtd201203,0.0) +  
isnull(Mtd201204,0.0) +  
isnull(Mtd201205,0.0) +  
isnull(Mtd201206,0.0) +  
isnull(Mtd201207,0.0) +  
isnull(Mtd201208,0.0) +  
isnull(Mtd201209,0.0) +  
isnull(Mtd201210,0.0) +  
isnull(Mtd201211,0.0) +  
isnull(Mtd201212,0.0) from dbo.RPT_resultA41 where companyid=1 and classify=1)
print @ytd