CREATE PROCEDURE usp_ins_cust(@cust_un varchar,
@cust_pw varchar,
@cust_fn varchar,
@cust_ln varchar,
@cust_addr varchar)
AS
BEGIN TRY
BEGIN TRANSACTION
INSERT INTO custlogin(custusename, custpassword) values (@cust_un, @cust_pw)
INSERT INTO custinfo(custid, custfirstname, custlastname, custaddress)
values (SCOPE_IDENTITY(), @cust_fn, @cust_ln, @cust_addr)
COMMIT
END TRY
BEGIN CATCH
ROLLBACK
END CATCH