insert tables

[calvi]

Is it possible to insert sql with several tables?
insert into 'tablename1', 'tablename2' (coluMn1, column2) values (column1value, column2value)
if not do ihave to have several sqlstring, command?

 

[SQLDenis]

an insert is always per table

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[bborissov]

No that query is not possible. You can insert result set from more than one table, but you can't insert records in more than one table.


Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[SQLDenis]

actually there is a way but you would have to create a partitioned view, you need check constraints on the table and you also need to make sure that the tables have identical DDL
then you would insert into the view and the view would insert into the correct table (so to speak)

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions