22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT NAME,ID FROM TB
DECLARE @SQL_COLUMNS NAVRCHAR(4000)
SELECT
@SQL_COLUMNS=ISNULL( @SQL_COLUMNS+',','')+[NAME]
FROM
SYSCOLUMNS
WHERE ID=OBJECT_ID('TB') AND NAME NOT IN(列名)
EXEC( 'SELECT '+@SQL_COLUMNS+' FROM TB')
DECLARE @SQL_COLUMNS NAVRCHAR(4000)
SELECT
@SQL_COLUMNS=ISNULL( @SQL_COLUMNS+',','')+NAME
FROM
SYSCOLUMNS
WHERE ID=OBJECT_ID('TB') AND NAME NOT IN(列名)
EXEC( 'SELECT '+@SQL_COLUMNS+' FROM TB')
EXEC( 'SELECT '+@SQL_COLUMNS+' FROM TB')
DECLARE @SQL_COLUMNS NAVRCHAR(4000)
SELECT
@SQL_COLUMNS=ISNULL( @SQL_COLUMNS+',','')+NAME
FROM
SYSCOLUMNS
WHERE ID=OBJECT_ID('TB') AND NAME NOT IN(列名)
select
*
from
syscolumns
where
name! = N'姓名' and ID = object_id('tb')-----表名tb,不包含列名为姓名的其它列