Create Proc InsertIntoMultipleTables
(
@Parameter1 Type,
@Parameter2 Type,
@Parameter3 Type
)
AS
Begin
insert into table1 (Col1, Col2) values (@Parameter1, @Parameter2)
insert into table2 (Col1, Col2) values (@Parameter1, @Parameter3)
End
Enjoy...
Nitin Verma