Sql查询一个表中除了某个字段以外的所有字段

declare @name varchar(100)
declare @sql varchar(1000)

SET @sql='select '
DECLARE C11 CURSOR FOR

select name from syscolumns where id=
(select max(id) from sysobjects where xtype='u' and name='表名')
and name <> '除外的字段'
OPEN C11

FETCH NEXT FROM C11 INTO
@name
IF @@FETCH_STATUS <> 0
BEGIN
DEALLOCATE C11
RETURN
END
WHILE(@@FETCH_STATUS = 0)
BEGIN
SET @sql=@sql+@name+','

FETCH NEXT FROM C11 INTO
@name
END
DEALLOCATE C11

set @sql=substring(@sql,1,len(@sql)-1)+' from 表名'

exec (@sql)

这段代码怎么用在编程里？建立存储过程？还是建立函数？如何使用？

select name from syscolumns where id=
(select max(id) from sysobjects where xtype='u' and name='表名')
and name <> '除外的字段' -> and name not in (' 除外的字段')

select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='表名') 然后去查不等于column1的值不就ok了 ，方法就这样了，具体你自己写去吧