1.创建测试表TEST
CREATE TABLE TEST
(
ID INT IDENTITY(1,1) PRIMARY KEY,
TESTNAME VARCHAR(50) NOT NULL,
TESTTYPE INT NOT NULL
)
GO
2.获取TEST表所有列名并用逗号隔开
DECLARE @COL VARCHAR(MAX)
SELECT @COL=ISNULL(@COL+',','')+NAME FROM SYS.COLUMNS WHERE OBJECT_ID=OBJECT_ID('TEST')
ORDER BY COLUMN_ID
PRINT @COL