Sql server stored procedure

Question

0.00/5 (No votes)

See more:

Hi All,

I need a small help from you all,

I have a table tab_1 with empid as primary key and I also have one more table tab_2 which also contains empid with no relation like primary or foreign key.

I need a procedure that if I insert empid details into tab_1 then i want to reflect the empid value to be inserted into tab_2 automatically.

Thank you all,

Posted 21-May-12 0:46am

jaipal0908

Add a Solution

Comments

Anil Honey 206 21-May-12 6:57am

How your inserting Empid in first table,Can u give me sample code

jaipal0908 21-May-12 7:03am

I written one stored procedure to insert the values into tab_1 like..
Insert into CaseMaster(empId,empTitle,empDesc)
values(@emp_Id,@emp_Title,@emp_description)

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)

sunandandutt · Answer 1 · 2012-05-21T01:11:00

Solution 1

Create a Trigger on tab_1 for inserted
and insert records into tab_2 in that trigger.

Posted 21-May-12 1:11am

sunandandutt

Comments

Unareshraju 21-May-12 7:15am

is it possible ?
is there any associated keys either forenkey or primary key.

sunandandutt 21-May-12 7:22am

no need
its possible. because in 2nd table you are just inserting records.

sunandandutt 21-May-12 7:23am

do you have knowledge of trigger?

jaipal0908 21-May-12 7:48am

Yes i have knowledge on trigger but i am using a stored procedure to insert the values into tab_1. Can inserting the empid value to the tab_2 be done using this sp.?If yes can anyone send me the code in sp?

Anil Honey 206 21-May-12 7:26am

But its the bad way Through Trigger your inserting the values in Table 2 instead of Trigger we can insert through Code.He should maintain Relation ship between two tables.

sunandandutt 21-May-12 7:31am

I think insertion throw code is slower then trigger.

jaipal0908 21-May-12 7:50am

Which is the best method to solve my problem,can u tell me how this is to be done using stored procedure?

sunandandutt 21-May-12 22:48pm

write different queries to insert data into two tables. if identity is automatically inserted then scop_identity will help you to insert perticular id into second table.

madhusudhan.k · Answer 2 · 2012-05-21T03:40:00

Solution 2

Hi..use the scope_identity() key to insert in second table.
You can use SP.

Posted 21-May-12 3:40am

madhusudhan.k

Comments

jaipal0908 21-May-12 9:45am

Hi madhusudhan,

Thank you very much,
Can you send me sample sp taking two tables and dummy columns.

Thank you,

madhusudhan.k · Answer 3 · 2012-05-21T03:57:00

Take a look at below example.

Ex : Table_1,Table_2
Table_1 with the Cols[empid(PK),empName]
Table_2 with the Cols[empid,empDecsr]

Create Procedure [name]
[Parameters]
As Begin

Declare @empid bigint
Insert into Table_1(empName)values('Madhu')

set @empid=(SELECT SCOPE_IDENTITY())

Insert into Table_2(empid,empDecsr)values(@empid,'xyz')

End

Hope this is helpful for you.

Regards
Madhu

Sql server stored procedure

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us