how to write stored procedure to insert values into two tables?

Apr 10 2010 7:30 AM

hi
how to write a single stored procedure to insert values into two tables at a time. columns are different in two tables. Please give a stored procedure, urgent please help me.
Thanks.

Answers (2)

one column of one table values is inserted in second table ata time?

SQL Server: Restrict the duplicate insertion of records to the database using Store Procedure