34,591
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE tmp(a INT,b int)
go
DECLARE @sql VARCHAR(10)
SET @sql = ''
SELECT @sql = @sql + ',' + CONVERT(VARCHAR(8000),c.name)
FROM syscolumns c
WHERE c.id = OBJECT_ID('tmp')
ORDER BY colid
SELECT @sql
/*
---------
,b
(1 row(s) affected)
*/
SET @sql = ''
SELECT @sql = @sql + ',' + CONVERT(VARCHAR(8000),c.name)
FROM syscolumns c
WHERE c.id = OBJECT_ID('tmp')
--ORDER BY colid
SELECT @sql
/*
----------
,a,b
(1 row(s) affected)
*/
GO
DROP TABLE tmp
输入字符 在 Transact-SQL 中的含义
;
查询分隔符
'
字符数据字符串分隔符
--
注释分隔符
/* ... */
注释分隔符。服务器不对 /* 和 */ 之间的注释进行处理。
Xp_
目录扩展存储过程的名称的开头,如 xp_cmdshell。
SELECT CONVERT(VARCHAR(8000),c.name)
FROM syscolumns c
WHERE c.id = OBJECT_ID('tmp')
ORDER BY colid
CREATE TABLE tmp(a INT,b int)
go
DECLARE @sql VARCHAR(10)
SET @sql = ''
SELECT @sql = @sql + ',' + CONVERT(VARCHAR(8000),c.name)
FROM syscolumns c
WHERE c.id = OBJECT_ID('tmp')
ORDER BY colid
SELECT @sql
/*
---------
,a,b
(1 row(s) affected)
*/
SET @sql = ''
SELECT @sql = @sql + ',' + CONVERT(VARCHAR(8000),c.name)
FROM syscolumns c
WHERE c.id = OBJECT_ID('tmp')
--ORDER BY colid
SELECT @sql
/*
----------
,a,b
(1 row(s) affected)
*/
GO
DROP TABLE tmp
CREATE TABLE tmp(a INT,b int)
go
DECLARE @sql VARCHAR(10)
SET @sql = ''
SELECT TOP 100 percent @sql = @sql + ',' + CONVERT(VARCHAR(8000),c.name)
FROM syscolumns c
WHERE c.id = OBJECT_ID('tmp')
ORDER BY colid
SELECT @sql
/*
---------
,b
(1 row(s) affected)
*/
SET @sql = ''
SELECT TOP 10000 @sql = @sql + ',' + CONVERT(VARCHAR(8000),c.name)
FROM syscolumns c
WHERE c.id = OBJECT_ID('tmp')
ORDER BY colid
SELECT @sql
/*
----------
,a,b
(1 row(s) affected)
*/
GO
DROP TABLE tmp