1
declare @Name varchar(30)
select @Name=(select top 1 c1 from c order by c3 desc)
exec ('select b1,(select sum(a1) from a where a3=1) as '+@Name+'1 from b')2
declare @Name varchar(30)
select @Name=(select top 1 c1 from c order by c3 desc)
declare @Sql varchar(4000)
select @Sql='select b1,(select sum(a1) from a where a3='
select @sql=@sql+convert(varchar(10),id)+') as '+@Name+convert(varchar(10),id)+',(select sum(a1) from a where a3=' from ***
select @sql=left(@sql,len(@sql)-33)+ ' from b'exec (@sql)
declare @Name varchar(30)
select @Name=(select top 1 c1 from c order by c3 desc)
exec ('select b1,(select sum(a1) from a where a3=1) as '+@Name+'1 from b')2
declare @Name varchar(30)
select @Name=(select top 1 c1 from c order by c3 desc)
declare @Sql varchar(4000)
select @Sql='select b1,(select sum(a1) from a where a3='
select @sql=@sql+convert(varchar(10),id)+') as '+@Name+convert(varchar(10),id)+',(select sum(a1) from a where a3=' from ***
select @sql=left(@sql,len(@sql)-33)+ ' from b'exec (@sql)
解决方案 »
- 根据表名查出该表的字段名,类型,长度等信息
- SQL语句,两个字段相减负数为零
- 取A表中的某字段的数据更新B表中的某字段,怎么写?
- 8GB的内存被sql server 2005用完了,怎么回事????
- sql server 数据库完整备份+增量备份的恢复
- 我用dotnet程序,访问远程sqlServer,非常慢,一个普通的一条数据的提交也要1分多钟
- 不知道是什么原因?请高手指点。
- 请问各位虾哥这两个查询怎么写?
- 如何分组?
- SQL从本表查到数据批量更新提示报错,是什么原因?
- 谁能帮我看看一个SQL Server 2000的脚本,通过读存储过程找出起始数据表和结果数据表,很急!
- 怎么在internet连接不到对方的 sql server数据库?
查询过来的值为变量@A 即select @a=sum(a1) from a where a3='1'
则:
select b1,@a as kk1 from b2。
用动态SQL
declare @a int,@i int
declare @sql nvarchar(4000)
select @a=max(a1) from a
set @sql='select b1,'
set @i=1
while @i<=@a
begin
set @sql=@sql+'(select sum(a1) from a where a3='+@i+') as kk'+cast(@i as varchar(3))
set @i=@i+1
end
set @sql=@sql+'from b'