删除重复值的问题

[gamevale]

表内容:

字段 nam a b c d e f g ...
值 dfds 0 0 0 1 2 0 3 ...
asdf 1 0 0 0 2 0 0


字段超过了200多个.有一个是字符型,其它均为数值型

我想把数值型大于0的值取出来应该如何操作啊.

[dawugui]

一个列大于0?

select * from tb where a>0 or b>0....

加起来大于0?
select * from tb where a+b+c... > 0

[gamevale]

字段200多个啊.有没有简单的?

[marco08]

查syscolumns表, 用動態SQL

[caixia615]

貌似没有。。。

[jackiecheng001]

select * from tb where tb.columnname in ( select name from syscolumns where object_id()= and user_type_id='')

[jackiecheng001]

select * from tb where tb.columnname in ( select name from syscolumns where object_id('tb')=id and xtype='56')