有表结构:
id name dept score
我原先使用语句:
select name score from table
但由于字段名称可能时不时改变,sql语句怎么写可以表达:我要显示 第二个和第四个字段?
------解决方案--------------------
- SQL code
select [name]from sys.columnswhere [object_id] = object_id('tbname') and column_id in (2,4)
select [name]from sys.columnswhere [object_id] = object_id('tbname') and column_id in (2,4)