在不知道列名的情况下选择表的前两列 [英] select first two columns of a table without knowing the column names

问题描述

我可以在不知道列名的情况下选择表的前两列吗?

在此先感谢.....

Hi,

Can I select first two columns of a table without knowing the column names??

Thanks in advance.....

推荐答案

检查此线程

SQL返回表的前两列 [ ^ ]

Check this thread

SQL to return first two columns of a table[^]

以及提供的链接thatraja，请查看此 [ ^ ].

Along with the link thatraja provided, have a look at this[^].

嗨...

检查以下TSQL脚本

Hi...

Check Following TSQL Script

IF OBJECT_ID('Employee') IS NOT NULL DROP TABLE dbo.Employee
CREATE TABLE dbo.Employee(ID INT, Name VARCHAR(30), Salary NUMERIC(10,2))

INSERT INTO dbo.Employee(ID,Name,Salary)
SELECT 1,'Kumar',1234.50
UNION ALL 
SELECT 2,'Prabu',12345.00
UNION ALL
SELECT 3,'Venkat',13455.45

DECLARE @SQLStr NVARCHAR(1000)
DECLARE @TableName VARCHAR(200)
DECLARE @NoOfColumns SMALLINT

SELECT @TableName='Employee',@NoOfColumns=2

SELECT @SQLStr=COALESCE(@SQLStr+',','')+Name FROM sys.Columns WHERE OBJECT_ID = OBJECT_ID(@TableName) AND Column_id <= @NoOfColumns

SELECT @SQLStr='SELECT '+@SQLStr+' FROM '+@TableName 

EXEC SP_EXECUTESQL @SQLStr

这篇关于在不知道列名的情况下选择表的前两列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！