求sql语句查询第2列的字段名
求sql语句查询第2列的字段名

[解决办法]

SQL code

select name from (select row_number()over(order by getdate()) as id,name from syscolumns where id=object_id('表名'))a where id=2
[解决办法]
SQL code
declare @table_name varchar(200)set @table_name = 'test'--表名称select o.name as table_name,c.name as colcumn_name,c.colorder,c.* from syscolumns c,sysobjects owhere c.id = o.idand o.xtype = 'u'and o.name = @table_nameand c.colorder = 2--只取第2个字段
[解决办法]
探讨

求sql语句查询第2列的字段名