Create Function GetOtherColumn(@TableName varchar(100)) Returns varchar(8000) As Begin Declare @S varchar(8000) Set @S='' Select @S=@S+','+Name from Syscolumns Where ID=OBJECT_ID(@TableName) And ColID>1 Order By ColID Return Stuff(@s,1,1,'') End GODeclare @sql varchar(8000) Set @sql='Select ' Set @sql=@sql+dbo.GetOtherColumn('Table') +' from Table' EXEC (@sql)
没有直接的就算了 我以为有类似except的东西
回复人: genggeng1206(庚庚) ( ) 信誉:100 Select 列名 From table where 列名!=a 我也是新手,嘿 嘿!~我支持这个老大,嘎嘎~~~
select b,c,... form table 显示中没有a 列了 就是说你不要显示就不要不那列的名称写入select语句中
先select * into #t from tbl 再把a列drop掉 再select * from #t
Create Function GetOtherColumn(@TableName varchar(100))
Returns varchar(8000)
As
Begin
Declare @S varchar(8000)
Set @S=''
Select @S=@S+','+Name from Syscolumns Where ID=OBJECT_ID(@TableName) And ColID>1 Order By ColID
Return Stuff(@s,1,1,'')
End
GODeclare @sql varchar(8000)
Set @sql='Select '
Set @sql=@sql+dbo.GetOtherColumn('Table') +' from Table'
EXEC (@sql)
我以为有类似except的东西
Select 列名 From table where 列名!=a
我也是新手,嘿 嘿!~我支持这个老大,嘎嘎~~~
显示中没有a 列了 就是说你不要显示就不要不那列的名称写入select语句中
再把a列drop掉
再select * from #t