Question

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

表中已知有Column1字段，能不能用一条select语句将Column1字段以外的其它字段都查询出来？
一楼的朋友太幽默了,如果有一百个字段,你就慢慢写吧

Answer 1

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)

Answer 2

select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='表名')
然后去查不等于Column1的值不就ok了 ，方法就这样了，具体你自己写去吧

Answer 3

select 字段1，字段2…… /* 这里除了column1的字段名 */
from 表名

Answer 4

有是有,不过要通过系统表来差,而且语句比较复杂,干嘛不连Column1也一起差出来呢?
select * from 表

Answer 5

select
name
from
syscolumns
where
id=
(select
max(id)
from
sysobjects
where
xtype='u'
and
name='表名')
and
name
<>
'除外的字段'
->
and
name
not
in
('
除外的字段')