请问如何将动态语句中的结果返回出来？

[waterstony]

如果有动态语句
SELECT @ls_SQL = 'SELECT SUM(' + @ls_col + ') FROM dbo.R06_ZBYELJB'
EXEC @ls_SQL

请问如何将合计的结果返回给一个变量？

[waterstony]

我用的是sybase的ase12。5，没有sp_executesql这个存储过程，还有没有别的什么办法？

[zarge]

建临时表

declare @num int,
@sqls nvarchar(4000)
create table #tmp (num int)
set @sqls='insert into #tmp select SUM(' + @ls_col + ') FROM dbo.R06_ZBYELJB'
exec(@sqls)

select num from #tmp

[txlicenhe]

declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=SUM(' + @ls_col + ') FROM dbo.R06_ZBYELJB'
exec sp_executesql @sqls,N'@a int output',@num output

select @num

[pengdali]

declare @sql nvarchar(1000),@id int
set @sql=N'select @ID = sum(' + @ls_col + ') from dbo.R06_ZBYELJB'

exec sp_executesql @sql,N'@id int output',@id output

select @id 结果

[hesyer]

up