Column Names From a Variable Without Execute Statement

[GrahamHills]

Is there anyway anyone knows of that i can select columns using variable names without building an execute statement??

ie.

DECLARE @col varchar(10)

SELECT @col = "AuditID"

SELECT @Col FROM tblAudit



Thanks

 

[NathanGriffiths]

Hi,

Can you explain why you need to do this without using EXECUTE?

thanks,

Nathan

 

[GrahamHills]

I've managed to solve this problem myself now.

 

[philhege]

For the benefit of those who are faced with the same problem, please be kind enough to:

1. Describe the problem.
2. Describe exactly what you did to solve the problem, preferably with sample code included.

That way, people who open this thread won't be disappointed when they expect to find an answer, or at least some discussion.

tks,
PH

 

[GrahamHills]

I did not want to use the Execute statement because I needed to create some Dynamic SQL Statements from values within the "deleted" and "inserted" tables in a trigger. I acheived this by simply creating two temporary tables with the contactents of the above tables and then was above to use those in an Execute statement as follows:-


SELECT * INTO #MyDeleted FROM deleted
SELECT * INTO #MyInserted FROM inserted