insert new records in two tables in single operation? 1

[Guest_imported]

Hi


I would like to insert new records into two tables at the same time, is there anyone
who could show me how to do this?


Cheers

Magnus

 

[foxdev]

I can't see how you could insert records into two different tables with the same INSERT statement - the command doesn't allow for this.

You could make it seem like that, though, by either:

1) using a trigger on the first table that makes the insert into the second table; or
2) calling a stored procedure rather than issuing the Insert statement, passing the SP the values to be inserted, and the SP does both inserts. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[mohmehran]

As foxdev says, it is impossible to insert into two tables in one statements. Even if you have a view defined on two tables, any insert statement on this view that references columns from two table will fail.

The reason to this constraint is that, since each TSQL statement is wrapped in its own transaction, the result of such a statement would be unknwon (COMMITED? or ROLLED BACK?)


Mohammad Mehran Nikoo, MCP
mohmehran@yahoo.com