SQL Insert Query

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Suppose there is two table in a database named like emp1 and emp2 and the fields are in emp1(emp_id,emp_name) and in emp2(emp_address,emp_sal). Now how can I insert all the value in emp1 and emp2 in a same sql insert query?

Posted 9-Jun-12 2:48am

Samiran Sarma

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

krumia · Answer 1 · 2012-06-09T03:13:00

Solution 1

Is there a good reason to keep these values in separate tables?

Or haven't you heard about Database Normalization[^]?

Posted 9-Jun-12 3:13am

krumia

Comments

thatraja 9-Jun-12 13:52pm

Right, 5!

Sandeep Mewara · Answer 2 · 2012-06-09T07:25:00

Solution 3

You cannot insert into two tables from a single SQL query.

If needed, you can try using Stored Procedure where calling one procedure will do the job (one SP can have multiple queries).
Refer:
MSDN: HOW TO: Call SQL Server Stored Procedures in ASP.NET by Using Visual C# .NET[^]
ADO.NET : Using Stored Procedures[^]
MSDN: CREATE PROCEDURE (Transact-SQL)[^]

Posted 9-Jun-12 7:25am

Sandeep Mewara

Comments

Tim Corey 9-Jun-12 22:31pm

+5 Good answer. You could also use one transaction with two insert statements (so if one insert fails the entire transaction gets rolled back).

Sandeep Mewara 10-Jun-12 2:17am

Thanks. Yep - transactions can be used.

pvchandana · Answer 3 · 2012-06-09T04:05:00

Solution 2

I think it not possible. You want to use two insert query or keep all records in one table

Posted 9-Jun-12 4:05am

pvchandana