How to Insert records in Two Related tables using Stored Procedures

[AsifRaja]

I have two tables here is the description:
Employees (E_ID(Primary key), Name, Address)
EmployeeEmails( E_ID(Foreign Key), EmailID(Primary Key), email)

I want to write a stored procedure which will insert record in Employees as well as Multiple Emails related to that perticular employee in EmployeeEmails Table....

I'll appreciate little help.

[Jim Doherty]

I have two tables here is the description:
Employees (E_ID(Primary key), Name, Address)
EmployeeEmails( E_ID(Foreign Key), EmailID(Primary Key), email)

I want to write a stored procedure which will insert record in Employees as well as Multiple Emails related to that perticular employee in EmployeeEmails Table....

I'll appreciate little help.

There are lots of reference to INSERTS that exist on the web. May I suggest that you attempt to show your understanding of:-

A) Where the data is coming from and in what format in order to insert it
B) Demonstrate some coding attempt yourself as to your understanding of that process.

I am sure contributor help will be forthcoming and appreciate this input from you.

Here is an MSDN link reference for you to look at insert syntax

http://msdn.microsoft.com/en-us/library/aa933206(SQL.80).aspx