求助。。。。。关于sql问题
耿俊才(耿俊才) 10:36:45
declare @i int
set @i=1
while @i<27
begin
declare @a nvarchar(20)
declare @b nvarchar(20)
declare @sql nvarchar(200)
select @b=timespk from tbs
where showorder=@i
select @a=tbname from tbs
where showorder=@i
SET @sql='SELECT max('+@b+') FROM '+@a
exec (@sql)
exec sql update tbs
set maxt=@sql---- 传递不过来
where showorder=@i
set @i=@i+1
end
[解决办法]
EXEC (@sql)之后就释放了,所以你后面用不了的,
[解决办法]
declare @i int
set @i=1
while @i<27
begin
declare @a nvarchar(20)
declare @b nvarchar(20)
declare @sql nvarchar(200)
select @b=timespk from tbs
where showorder=@i
select @a=tbname from tbs
where showorder=@i
SET @sql='SELECT max('+@b+') FROM '+@a
exec (@sql)
EXEC('update tbs
set maxt=('+@sql+')
where showorder='+LTRIM(@i)
)set @i=@i+1
end
猜想楼主应该是这意思吧