读书人

该怎样写参数,该怎么解决

发布时间: 2012-11-04 10:42:42 作者: rapoo

该怎样写参数

SQL code
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


[解决办法]
终于明白了:
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

读书人网 >SQL Server

热点推荐