Stored procedure for sql server 2005

Question

0.00/5 (No votes)

See more:

I have 1 table having no of fields empid as primary key for table1 & for table 2 i used empid as foreign key.I used stored procedure for insert the data. Table 2 having
emp education details with university,yearof passing etc columns.i want to insert the records in table 2 with empid.For that i want stored procedure.
Deatiled view of table

Table1
empid
name
address
mob.no
etc
Table2
empid
university
year of passing
Major subject
all are having 3 textboxes
i want to insert the record from all 3 text boxes to table2 with empid
For that i want stored procedure & vb.net code.

Thanx in advance

Posted 8-Sep-11 4:13am

vishaalmandge

Updated 8-Sep-11 9:21am

MaulikDusara

v3

Add a Solution

Comments

[no name] 8-Sep-11 15:24pm

hi,
first try your self.

2 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)

Corporal Agarn · Answer 1 · 2011-09-08T08:10:00

Solution 1

Look at the OUTPUT[^] clause.

After inserting into one table you have information that is needed to insert into another.

Posted 8-Sep-11 8:10am

Corporal Agarn

angappans · Answer 2 · 2011-09-08T23:18:00

hai

use this stored procedure and try to use insert values in table in your vb code..

drop procedure sp_insert<br />
go<br />
create procedure sp_insert<br />
@p_ename varchar(50),@p_ecity varchar(50),@p_eid bigint,@p_empedu varchar(50),@p_empuni varchar(50)<br />
as <br />
declare @eid int<br />
begin <br />
insert into empinfo(empname,empcity) values(@p_ename,@p_ecity)<br />
set @eid=@@identity<br />
if(@eid!=0)<br />
insert into empstu(empid,empedu,empuni)values(@p_eid,@p_empedu,@p_empuni)<br />
select @eid<br />
end

try it..
i hope this is useful to you..
take care ....