Table as a variable

#1

I am reading a list of tables from a table and wish to execute a SQL
statement for each table from this list. I tried declaring @table_name,
depositing the table name from my table-list data. However, the "Select *
from @table_name" SQL fails. Any ideas?

#2

Have a look at this:
http://www.sommarskog.se/dynamic_sql.html

--
Andrew J. Kelly SQL MVP

"Timothy Peer" <TimothyPeer (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am reading a list of tables from a table and wish to execute a SQL
statement for each table from this list. I tried declaring @table_name,
depositing the table name from my table-list data. However, the "Select *
from @table_name" SQL fails. Any ideas?

#3

Hi,
I think there is problrm with the query it should be

declare @query varchar(2000)

sert @query='select * from ' +@@table_name

exec (@query)

This should work

"Timothy Peer" wrote:

Quote:

I am reading a list of tables from a table and wish to execute a SQL
statement for each table from this list. I tried declaring @table_name,
depositing the table name from my table-list data. However, the "Select *
from @table_name" SQL fails. Any ideas?

#4

Hi,
I think there is problrm with the query it should be

declare @query varchar(2000)

sert @query='select * from ' +@@table_name

exec (@query)

This should work

"Timothy Peer" wrote:

Quote:

I am reading a list of tables from a table and wish to execute a SQL
statement for each table from this list. I tried declaring @table_name,
depositing the table name from my table-list data. However, the "Select *
from @table_name" SQL fails. Any ideas?

#5

Hi,
I think there is problrm with the query it should be

declare @query varchar(2000)

sert @query='select * from ' +@@table_name

exec (@query)

This should work

"Timothy Peer" wrote:

Quote:

I am reading a list of tables from a table and wish to execute a SQL
statement for each table from this list. I tried declaring @table_name,
depositing the table name from my table-list data. However, the "Select *
from @table_name" SQL fails. Any ideas?

#6

Hi,
I think there is problrm with the query it should be

declare @query varchar(2000)

sert @query='select * from ' +@@table_name

exec (@query)

This should work

"Timothy Peer" wrote:

Quote:

I am reading a list of tables from a table and wish to execute a SQL
statement for each table from this list. I tried declaring @table_name,
depositing the table name from my table-list data. However, the "Select *
from @table_name" SQL fails. Any ideas?

#7

Hi,
I think there is problrm with the query it should be

declare @query varchar(2000)

sert @query='select * from ' +@@table_name

exec (@query)

This should work

"Timothy Peer" wrote:

Quote:

I am reading a list of tables from a table and wish to execute a SQL
statement for each table from this list. I tried declaring @table_name,
depositing the table name from my table-list data. However, the "Select *
from @table_name" SQL fails. Any ideas?

#8

Hi,
I think there is problrm with the query it should be

declare @query varchar(2000)

sert @query='select * from ' +@@table_name

exec (@query)

This should work

"Timothy Peer" wrote:

Quote:

I am reading a list of tables from a table and wish to execute a SQL
statement for each table from this list. I tried declaring @table_name,
depositing the table name from my table-list data. However, the "Select *
from @table_name" SQL fails. Any ideas?

#9

Hi,
I think there is problrm with the query it should be

declare @query varchar(2000)

sert @query='select * from ' +@@table_name

exec (@query)

This should work

"Timothy Peer" wrote:

Quote:

I am reading a list of tables from a table and wish to execute a SQL
statement for each table from this list. I tried declaring @table_name,
depositing the table name from my table-list data. However, the "Select *
from @table_name" SQL fails. Any ideas?

#10

Hi,
I think there is problrm with the query it should be

declare @query varchar(2000)

sert @query='select * from ' +@@table_name

exec (@query)

This should work

"Timothy Peer" wrote:

Quote:

I am reading a list of tables from a table and wish to execute a SQL
statement for each table from this list. I tried declaring @table_name,
depositing the table name from my table-list data. However, the "Select *
from @table_name" SQL fails. Any ideas?