这个貌似只能用循环加动态sql去解决，一条语句实在想不出来
IF object_id('tempdb.dbo.#t') is not null
drop table #t
declare @col1 varchar(1),@col2 varchar(2),@col3 varchar(2),@col4 varchar(800),@sql nvarchar(2000)
create table #t
(
[col1] varchar(1),
[col2] varchar(2),
[col3] varchar(2),
[col4] varchar(800))
declare c1 cursor for
select * from tb
open c1
fetch next from c1 into @col1,@col2,@col3,@col4
WHILE @@FETCH_STATUS = 0
begin
print @col1
set @sql='insert into #t select '+''''+@col1+''''+','+''''+@col2+''''+','+''''+@col3+''''+','+''''+@col4+''''+' where '+@col4
print @sql
exec(@sql)
fetch next from c1 into @col1,@col2,@col3,@col4
end
CLOSE c1
DEALLOCATE c1
select * from #t
