SQL查询，排除指定字段

摘自：http://blog.163.com/tianshenglongchang@126/blog/static/164628503201231925214824/

查询除指定字段外的所有字段

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='表名')

转载于:https://www.cnblogs.com/sulong/p/4800795.html