Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Using variables in FROM Clause or SELECT list ?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-16 : 18:43:11
Filip writes "Dear SQL Expert,

Is it possible in SQL Server to use a variable in the FROM or SELECT list ?
In a stored procedure i wanted to do something like SELECT * FROM @Param .
But as SQL Expert , you will know that this isn't working ...
After hours digging in the MSDN, i moved the code to a com object.
But as a matter of fact, i'm very curious if it's possible in TSQL.

Thanks for your advise.

Filip"
   

- Advertisement -