T-SQL

[veledrom]

Hi,

This T-SQL works fine but i just want to make sure that it is also reliable. Do you think this is reliable?

Thanks

CREATE DEFINER=`root`@`localhost` PROCEDURE `addNewUser`(IN username_in varchar(15), password_in varchar(40), name_in varchar(25), surname_in varchar(25), dob_in date, address_in varchar(50), postcode_in varchar(8), city_in varchar(20), phone_in varchar(14), email_in varchar(50))

BEGIN
	DECLARE addedId INT;
	DECLARE rowCount INT DEFAULT 0;

	SET AUTOCOMMIT=0;
	START TRANSACTION;

	INSERT INTO access (username, `password`)
	VALUES (username_in, SHA1(password_in));

	SELECT row_count() INTO rowCount;

	IF (rowCount=1) THEN	
		SET rowCount=0;	

		SELECT id INTO addedId
		FROM access
		WHERE username=username_in;

		INSERT INTO customer (name, surname, dob, address, postcode, city, phone, email, accessId) VALUES (name_in, surname_in, dob_in, address_in, postcode_in, city_in, phone_in, email_in, addedId);

		SELECT row_count() INTO rowCount;

		IF (rowCount=1) THEN
			COMMIT;
		ELSE		
			ROLLBACK;
		END IF;
	END IF;
END;