展开全部
给你做了一个简单的例子 ,你自己62616964757a686964616fe58685e5aeb931333332623434思考一下USE tempdb
GO
IF OBJECT_ID('TABLE1') IS NOT NULL
DROP TABLE TABLE1
GO
CREATE TABLE TABLE1
(cWhCode NVARCHAR(20))
INSERT INTO TABLE1
SELECT 'W01' UNION ALL
SELECT 'W02' UNION ALL
SELECT 'W03' UNION ALL
SELECT 'W04' UNION ALL
SELECT 'W05'
GO
IF OBJECT_ID('TABLE2') IS NOT NULL
DROP TABLE TABLE2
GO
CREATE TABLE TABLE2
(
W01 NVARCHAR(20),
W02 NVARCHAR(20),
W03 NVARCHAR(20),
W04 NVARCHAR(20),
W05 NVARCHAR(20)
)
DECLARE @COL NVARCHAR(1000)
SET @COL=''
--拼接动态语句
SELECT @COL=@COL+',' + CWHCODE FROM TABLE1
SET @COL= STUFF(@COL,1,1,'')
--动态查询
exec ('SELECT ' + @COL + ' FROM TABLE2')