sqlserver有没有办法查询表里第几的字段的值

Question

现在字段名未知， 我要查第三个字段的值。。。。

Answer 1

在SQL Server无法直接实现，参考：Access columns of a table by index instead of name in SQL Server stored procedureSELECT columns by column-index NOT by columnname建议在代码中实现

Answer 2

Select name from syscolumns Where ID=OBJECT_ID('表名')

Answer 3

USE TEMPDBGOIF OBJECT_ID('TB') IS NOT NULL DROP TABLE TBGOCREATE TABLE TB(COL1 INT,COL2 INT,COL3 INT,COL4 INT)GODECLARE @SQL VARCHAR(MAX)SELECT @SQL='SELECT '+NAME+' FROM TB'FROM SYS.COLUMNSWHERE OBJECT_ID=OBJECT_ID('TB')AND COLUMN_ID=3EXEC (@SQL)