exec('select sum(数量) from '+@table)
运行正常
select @c=sum(数量) from 仓库_1
运行正常
exec('select @c=sum(数量) from '+@table)
运行不正常
这句该怎样写才正确?
运行正常
select @c=sum(数量) from 仓库_1
运行正常
exec('select @c=sum(数量) from '+@table)
运行不正常
这句该怎样写才正确?
调试欢乐多
set str = "declare @c varchar(20); varchar(20);select @c = sum(数量) from " + @table ;
sp_ExcuteSql(str);//sp_ExcuteSql函数应该是这样的
@c在那里声明
exec('declare @c float select @c=sum(列) from table print(@c)')
这样写
declare @sqlstr nvarchar(1000)
declare @c int
set @sqlstr=N'select @c=count(*) from sysobjects'
exec sp_executesql
@sqlstr,
N'@c int output',
@c=@c output
select @c
http://topic.csdn.net/u/20080429/01/ccb2d78d-d7cd-4332-8fd8-667714f2ed62.html
exec('select '+ @c + '=sum(数量) from '+@table)