如何在sql中选择除一列以外的所有列? [英] How to select all columns in sql except one column?
本文介绍了如何在sql中选择除一列以外的所有列?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Possible Duplicate:
SQL exclude a column using SELECT * [except columnA] FROM tableA?
是否可能选择除一列之外的所有列?
Is selecting all columns except one column possible??
这是所有列名称:ID,名称,地址,年龄
here is all column names: id, name, address, age
SELECT id, name, address from TBLUser
我不想使用此select语句,因为我的表的列数彼此不同.
I don't want to use this select statement because the number of columns of my tables are different to each other.
推荐答案
declare @cols varchar(max), @sql varchar(max)
SELECT @cols = STUFF
(
(
SELECT DISTINCT '], [' + name
FROM sys.columns
where object_id = (
select top 1 object_id from sys.objects
where name = 'TBLUser'
)
and name not in ('age')
FOR XML PATH('')
), 1, 2, ''
) + ']'
select @sql = 'select ' + @cols + ' from TBLUser'
exec (@sql)
这篇关于如何在sql中选择除一列以外的所有列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文