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

Question

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

Answer 1

在SQL Server无法直接实现，参考：

• Access columns of a table by index instead of name in SQL Server stored procedure

• SELECT columns by column-index NOT by columnname

建议在代码中实现

Answer 2

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

Answer 3

USE TEMPDB
GO
IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB
GO
CREATE TABLE TB(
COL1 INT
,COL2 INT
,COL3 INT
,COL4 INT
)
GO
DECLARE @SQL VARCHAR(MAX)
SELECT @SQL='SELECT '+NAME+' FROM TB'
FROM SYS.COLUMNS
WHERE OBJECT_ID=OBJECT_ID('TB')
AND COLUMN_ID=3

EXEC (@SQL)