declare @s varchar(1000)
set @s=''
select @s=@s+name+',' from syscolumns
where id=object_id('tablename')
and name<>'b'
set @s='select '+left(@s,len(@s)-1)+' from tablename'
exec (@s)
set @s=''
select @s=@s+name+',' from syscolumns
where id=object_id('tablename')
and name<>'b'
set @s='select '+left(@s,len(@s)-1)+' from tablename'
exec (@s)
那么
create view exp
as
select a,c,d from table
go
以后的不显示字段b查询就直接引用视图exp就行了
select * from exp
那还是要写一次select a,c,d from table啊。
多写几个名称也嫌罗嗦!!!!!!!!!!
select a,c,d from table,这样写不很好吗?
除了複製表結構(SELECT INTO #copy * FROM T WHERE 1 <> 1 )
的情款下, 都奈點煩.不然需求有變 就頭大