can use variable in the from clause

Question

Post reply

can use variable in the from clause

palmdev2002

SSC Enthusiast

Points: 154
More actions
March 28, 2002 at 10:57 am

#104836

Is it possible to pass the parameter to the from clause? For example, select @id =max(keyid) from @tablename or insert into @table1 select * from @table2.
Cheers
Dev

Cheers

Dev

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

not directly. You can, however, use dynamic sql for this.

Steve Jones

steve@dkranch.net

palmdev2002 SSC Enthusiast Points: 154 More actions · Answer 2

Do you mean to use exec() function? Yes, it works, but how can I get the result from the dynamic sql, like select @result=max(id) from @tablename. Could you give me an example on how to do that?

quote:
not directly. You can, however, use dynamic sql for this.
Steve Jones
steve@dkranch.net

Cheers

Dev

Cheers

Dev

crosspatch Hall of Fame Points: 3168 More actions · Answer 3

Typically a call to Dynamic SQL would look like EXEC('SELECT ' + @columnname + ' FROM ' + @tablename), but I suspect you know that.

Could you post a fuller example of what you are trying to do.

I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961