Click here to Skip to main content
12,626,035 members (28,455 online)
Rate this:
 
Please Sign up or sign in to vote.
I have two tables named
table 1->a
coloumns are- a1,a2

and
table 2->b
coloumns are b1,b2

I want to insert values in both at once . with the query
insert into a(a1),b(b1)values(1,2)

But It not work.
Help me regarding This
Posted 22-Jan-13 0:59am
ankur7891.5K
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

You simply cannot do this in SQL Server.
The only workaround is to right two statements to insert into the tables.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

"Insert into tb1 (col1, col2, col3) values (@col1, @col2, @col3); Insert into tb2 (col1, col2, col3) values (@col1, @col2, @col3);"
  Permalink  
v4
Comments
AnkurGupta OM 23-Jan-13 2:26am
   
Thank You

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.161205.3 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100