Table as a variable

#41

<smzrkh (AT) gmail (DOT) com> wrote

Quote:

This, also, will not work. You cannot use a variable in the FROM clause
of a
query under any conditions.

The above concept is valid; however, the execution is incorrect.

Given a preexisting variable @table_name containing a valid two-part
table
name.

DECLARE @query varchar(max)
SET @query = 'SELECT * FROM ' + @table_name
EXEC (@query)

You could also skip the @query variable and simply:

EXEC('SELECT * FROM ' + @table_name)

Quote:

what about a cursor?

What about it?

--
Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
Principal/CTO, Onsite Technology Solutions, Houston, Texas

#42

<smzrkh (AT) gmail (DOT) com> wrote

Quote:

This, also, will not work. You cannot use a variable in the FROM clause
of a
query under any conditions.

The above concept is valid; however, the execution is incorrect.

Given a preexisting variable @table_name containing a valid two-part
table
name.

DECLARE @query varchar(max)
SET @query = 'SELECT * FROM ' + @table_name
EXEC (@query)

You could also skip the @query variable and simply:

EXEC('SELECT * FROM ' + @table_name)

Quote:

what about a cursor?

What about it?

--
Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
Principal/CTO, Onsite Technology Solutions, Houston, Texas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Table as a variable

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Table as a variable - 12-10-2008 , 09:09 AM

Re: Table as a variable - 12-10-2008 , 09:09 AM