create table 表名(name varchar(1)) insert into tb values('a') insert into tb values('b') insert into tb values('c') declare @sql varchar(8000) set @sql = 'insert into 新表 select ' select @sql = @sql + ', max(case name when ''' + cast(name as varchar) + ''' then name end) [' + name + ']' from 表名 set @sql = 'select ' + substring(@sql , 9 , len(@sql)) + ' from 表名' exec(@sql)
1 INSERT INTO tb EXEC(@sql) 2 把 into table 嵌在@sql中.
这是您昨天写的那个!!现在想把exec(@sql)的显示结果写进一张表里 写的同时建立新表 可否做到呢 INSERT INTO 好像是插入数据!!!!!
declare @sql varchar(8000) set @sql = 'select ' select @sql = @sql + ', max(case name when ''' + cast(name as varchar) + ''' then name end) [' + name + ']' into 新表----- from 表名 set @sql = 'select ' + substring(@sql , 9 , len(@sql)) + ' from 表名' exec(@sql)
declare @sql varchar(8000) set @sql = 'select ' select @sql = @sql + ', max(case name when ''' + cast(name as varchar) + ''' then name end) [' + name + ']' from 表名 set @sql = 'select ' + substring(@sql , 9 , len(@sql)) + ' into 新表 from 表名' exec(@sql) 马虎了
insert 表名 select * from 其他表名 插入数据难道不是从表的最后一行开始插入数据吗》》我这为什么是从第一行开始插入数据的呢??
insert into tb values('a')
insert into tb values('b')
insert into tb values('c')declare @sql varchar(8000)
set @sql = 'select '
select @sql = @sql + ', max(case name when ''' + cast(name as varchar) + ''' then name end) [' + name + ']'
from 表名
set @sql = 'select ' + substring(@sql , 9 , len(@sql)) + 'into 表1 from 表名'
exec(@sql)
create table 表名(name varchar(1))
insert into tb values('a')
insert into tb values('b')
insert into tb values('c') declare @sql varchar(8000)
set @sql = 'insert into 新表 select '
select @sql = @sql + ', max(case name when ''' + cast(name as varchar) + ''' then name end) [' + name + ']'
from 表名
set @sql = 'select ' + substring(@sql , 9 , len(@sql)) + ' from 表名'
exec(@sql)
1 INSERT INTO tb EXEC(@sql)
2 把 into table 嵌在@sql中.
set @sql = 'select '
select @sql = @sql + ', max(case name when ''' + cast(name as varchar) + ''' then name end) [' + name + ']'
into 新表-----
from 表名
set @sql = 'select ' + substring(@sql , 9 , len(@sql)) + ' from 表名'
exec(@sql)
set @sql = 'select '
select @sql = @sql + ', max(case name when ''' + cast(name as varchar) + ''' then name end) [' + name + ']'
from 表名
set @sql = 'select ' + substring(@sql , 9 , len(@sql)) + ' into 新表 from 表名'
exec(@sql)
马虎了