笔记222 选择表全部列数据除了某列

笔记222 选择表全部列数据除了某列

--选择表全部列数据除了某列
USE [pratice]
GO

create view vtest
as
select 1 as a,2 as b ,3 as c
go

SELECT * FROM vtest


declare @s varchar(1000)

select @s = isnull(@s+',','') +name
from syscolumns
where id = OBJECT_ID('vtest') and name <> 'a'

exec('select '+ @s + ' from vtest')

drop view vtest