declare @SumJE float declare @DataBase varchar(10) .... exec sp_executesql 'Select @a=Sum(JE) From '+@DataBase,N'@a int output',@SumJE output
declare @SumJE int , @sqls nvarchar(4000) set @DataBase='......' set @sqls='Select @a=Sum(JE) From '+@DataBase exec sp_executesql @sqls,N'@a int output',@SumJE output select @SumJE
declare @SumJE float declare @DataBase varchar(10) Set @SumJE = (Select Sum(JE) From '+@DataBase+') 我的意思是将动态表的金额字段求和然后付给变量@SumJE,请各位帮忙。
declare @SumJE float declare @DataBase varchar(10) Set @SumJE = (Select Sum(JE) From @DataBase)
sunrisehy2003(黎明) 你写的无法在查询分析器中执行。
Set @SumJE = (Select Sum(Cast(JE as numeric(18,2))) From LS_YW1 ) 我想将数据表名称[LS_YW1] 换成变量@DataBase此语句应该怎麽写? 所写的语句必须能在SQL Server7.0查询分析器中执行。请大家帮忙,谢谢...
declare @DataBase varchar(10)
....
exec sp_executesql 'Select @a=Sum(JE) From '+@DataBase,N'@a int output',@SumJE output
@sqls nvarchar(4000)
set @DataBase='......'
set @sqls='Select @a=Sum(JE) From '+@DataBase
exec sp_executesql @sqls,N'@a int output',@SumJE output
select @SumJE
declare @DataBase varchar(10)
Set @SumJE = (Select Sum(JE) From '+@DataBase+')
我的意思是将动态表的金额字段求和然后付给变量@SumJE,请各位帮忙。
declare @DataBase varchar(10)
Set @SumJE = (Select Sum(JE) From @DataBase)
你写的无法在查询分析器中执行。
我想将数据表名称[LS_YW1] 换成变量@DataBase此语句应该怎麽写?
所写的语句必须能在SQL Server7.0查询分析器中执行。请大家帮忙,谢谢...