27,579
社区成员
发帖
与我相关
我的任务
分享
Use tempdb
create table tt
(F001 nvarchar(10), F002 nvarchar(10), F003 nvarchar(10), F004 nvarchar(10),
F005 nvarchar(10), F006 nvarchar(10), F007 nvarchar(10), F008 nvarchar(10),
F009 nvarchar(10))
insert tt
select N'谢', N'谢', N'各', N'位', N'大', N'侠', N'的', N'帮', N'助'
select * from tt
select W1, W2
from tt
unpivot (W2 for W1 in (F001, F002, F003, F004, F005, F006, F007, F008, F009)) as t
drop table tt
/*测试数据*/
CREATE TABLE tt(f001 VARCHAR(10),f002 VARCHAR(10),f003 VARCHAR(10),
f004 VARCHAR(10),f005 VARCHAR(10),f006 VARCHAR(10),f007 VARCHAR(10),f008 VARCHAR(10),f009 VARCHAR(10))
INSERT INTO tt
SELECT '谢','谢','各','位','大','虾','的','帮','助'
SELECT * FROM tt
DECLARE @sql VARCHAR(8000)
SELECT @sql = COALESCE(@sql,'')+'union all select '''+[name]+''' as [w1],'+[name]+' as [w2] from tt '
FROM SysColumns Where ID = OBJECT_ID(N'tt') Order By ColID
SET @sql=STUFF(@sql,1,9,'')
--PRINT @sql
EXEC (@sql)