How to get Column Value From a Statement if Table Name passes dynamically through a variable....?

[Manish_Kumar_Nayak]

In SQL Server 2005... How to get Column Value From a Statement if Table Name passes dynamically through a variable....?

[Mycroft Holmes]

You need to use dynamic sql in your prodecure.

Declare @SQL varchar(100)

set @SQL = 'Select ' + @Field + ',' + @Field2 +' from TableName'

Exec (@SQL)

Never underestimate the power of human stupidity RAH

[Manish_Kumar_Nayak]

Declare one more variable and assign first column value and Print this value....... Okay..........

[PIEBALDconsult]

But why use a stored procedure at all? Just do the same thing but in regular code.