STORED PROCEDURE

Question

HELLO I HAVE CREATED A REGISTRATION FORM AND LOGIN FORM AND I HAVE STORED PROCEDURE FOR REGISTRATION FORM AND I WANT WHEN THE USER SUBMITS THE FORM THE DATA SHOULD ENTER BOTH THE TABLE...HOW CAN I ACHEIVE IT..HELP NEEDED.

Rahul Bansal · Answer

Try this like CREATE procedure [dbo].[Usp_Registration] ( @Value1 varchar(10) @Value2 varchar(10) @Value3 varchar(10) ) As Begin INSERT Into Table1(Column1column2) values(@Value1@Value2) INSERT Into Table2(Column1column2column3) values(@Value1@Value2@Value3) End

Joginder Banger · Answer

Hi Anjali you have no mention design of both table first of all why are used the two table you can user login form on same table. I think its very easy. plz share your table.