Using column name in select statement?? 1

[bdotzour]

I want to do this:

create procedure simple
@col char(40)
as
select * from @col

But that doesn't work. Can anyone help me find out how to pass a variable containing a column name and then use that variable in the select statement?

Thanks!

 

[tlbroadbent]

Column names belong in the Select List. Table names belong in the From clause.

You can do the following.

create procedure simple
@col varchar(40)
as
declare @sql nvarchar(256)
Set @sql="select " + @col + " From tblname"
exec sp_executesql @sql
Go
Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.

 

[bdotzour]

Fantastic! Of course you were right about the mixup, but i'm glad you knew what i meant.

Thanks so much.