Insert into more than one table

Hot Topic

Why can I not read VARCHAR(MAX)?
Configure SQL Express to utilize Windows clustering
How to get a row committed
what is the meaning of "64(error not found)" in sys.transmission_queue
Looping through an excel spreadsheet
No message in the TargetQueue
Determining is a database is a subscriber
EMail Task Problem
Issue with launching Report Builder from client PC's
Query not producing correct results and Group By Error

SQL Server

Is there a way to protect an olap db meta data - technically
service broker message on remote instance not working
SQL 2005 Compatibility Level
Using Rank() inside a stored procedure
Broker:Corrupted message
Script Task - Validation Error / Unable to cast COM object... (Sep CTP)
Dynamically Passing a Dataset to a Report in Reporting Services 2005
GACing components
How to show the border of the table?
VS2005 Team Suit + SQL Server 2005 Enterprise ???

Insert into more than one table

I have this select command

SELECT intUserId FROM tblUser

I want to insert every intUserId into tblUserBla,tblUserBla2

I know that i can do this

INSERT INTO tblUserBla (intUserId) SELECT intUserId FROM TblUser

But, how can i perform a insert into tow tables, in one statement



Answer this question

Insert into more than one table

  • Jenkins

    But how can my trigger get my intUserId

  • areisinger

    this will be the body of the after insert trigger on the first table
    insert into [2nd table] select intUserId from inserted
    which will insert only the newly inserted IDs

  • ISH_STEPHAN

    Thank you very much

  • Thad

    you can add a trigger in the first table that inserts the required values into the 2nd table after the insertion



  • Insert into more than one table
Answer this question