Home Forums SQL Server 7,2000 T-SQL Dynamically selecting column RE: Dynamically selecting column
ekalos
SSC Journeyman
Points: 75
More actions
April 15, 2004 at 9:07 pm
#503057
Try this guy out....not pretty, but might work for you.
CREATE PROCEDURE GetRows
@Column varchar(25)
AS
DECLARE @Sql Varchar(50)
SET @Sql = 'SELECT ' + @Column + ' FROM Table1'
EXEC (@Sql)
GO