Luca,
I believe what you are looking for is somewhat along the lines of
There are other ways to do it by piecing together the string on the fly.
The key is the Exec(ute) portion. For more information, take a look at BOL.
John Gose
MCDBA
Microsoft SQL Server Support
This posting is provided "AS IS", with no warranties, and confers no rights
Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
| Content-Class: urn:content-classes:message
| Subject: Parametric FROM clause
| Date: Fri, 11 Jan 2002 06:59:22 -0800
| Lines: 40
|
<Snip of Header Stuff>
|
| Hi,
|
| I try to make an example
|
|
| SELECT *
|
|
|
| Thanks,
| Luca
|
|
Quote:| >-----Original Message-----
| >hi
| >
| >i not really understand your question.could you give an
| >example what are you trying to do?
| >
| >alex lim
| >avanade malaysia
| >>-----Original Message-----
| >>Hi,
| >>
| >>can anyone tell me if is possible to refer to a table in
| >a
| >>FROM clause using a parameter or a variable?
| >>
| >>Thanks,
| >>
| >>Luca
| >>
| >>
| >>.
| >>
| >.
| >
|