September 6, 2005 at 11:27 am
How I Can use the Field Name of Table as a Parameter without use:
Exec ('Select * from Table_Name where @Field_Name = '10')
Only into the SQL Statement
Something like that:
SET @Field_Name = 'Field'
SELECT @Field_Name from Table_Name where @Field_Name = '10'
Tanks
September 6, 2005 at 11:30 am
You can't. Why do you need to do that?
The Curse and Blessings of Dynamic SQL
September 6, 2005 at 11:34 am
Thanks for answer.
Just I wanna know how to make more general some procedures, and soo expand the posibilities into those procedures.
I gonna read your suggentions, Thanks rqR'us
September 6, 2005 at 11:36 am
The short answer to that question is don't do that. You waste all the power of sql server when you do something like that.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply