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]

@AsifRaja
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/libr...6(SQL.80).aspx