inserting multiple values in multiple value?

[nowayout]

Hi all

I want to insert multiple valuse from query command as follow

insert into dbname.dbo.tablename

select * from (all the tables or multiple tables)


how would i show to select from all the table or selecting from multiple table at a time.

Thanks,,,

 

[sguslan]

You did not explain what the other tables are. But it seems you need to insert rows from multiple tables with the same structure.

insert into dbname.dbo.tablename

select * from tab1
union
select * from tab2
union
select * from tab3
union
select * from tab4


and so on ...
________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[nowayout]

oh ok i am sorry for that

i would really like to insert in to

insert into multiple or all the table name

select * from all the table from different database

 

[sunila7]

Hi,

I think u r looking to import data from one Database to another, use Import/Export Wizard(Data transformation services DTS) to do that.


hope it helps....


Sunil

 

[nowayout]

yeah but i was just wondering what will be the sentext in SQL command, i have tried from importing it and it did work but still wanted to know how would i be able to query it.

thanks

 

[tlbroadbent]

You must write a query for each insert. You cannot write a single statment to insert into multiple tables. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm