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

declare @name varchar(100)declare @sql varchar(1000)SET @sql='select 'DECLARE C11 CURSOR FORselect name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='Album')//Album为表名and name <> 'AlbumID'//AlbumID为要除去的表字段OPEN C11FETCH NEXT FROM C11 INTO @nameIF @@FETCH_STATUS <> 0 BEGINDEALLOCATE C11RETURNEND WHILE(@@FETCH_STATUS = 0)BEGINSET @sql=@sql+@name+','FETCH NEXT FROM C11 INTO @nameENDDEALLOCATE C11set @sql=substring(@sql,1,len(@sql)-1)+' from Album'//Album为表名exec (@sql)

图片如下：

转载于:https://www.cnblogs.com/Mygirl/archive/2011/11/08/2241243.html