STORED PROCEDURE
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.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rahul BansalPosted Mar 16, 2015, 2:32 AM
CREATE procedure [dbo].[Usp_Registration]
(
@Value1 varchar(10),
@Value2 varchar(10),
@Value3 varchar(10)
)
As
Begin
INSERT Into Table1(Column1,column2) values(@Value1,@Value2)
INSERT Into Table2(Column1,column2,column3) values(@Value1,@Value2,@Value3)
End
Joginder BangerPosted Mar 16, 2015, 2:28 AM
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.