Convertion from MS Sql to MySql
Hi All,
Below I have given a stored procedure for User Registration in MS Sql
/******Stored Procedure MS Sql Starts Here*******/
CREATE PROC InsertRegDetails
(
@UserId numeric(9) ,
@FName varchar(50),
@LName varchar(50),
@Email varchar(100),
@DepartmentName varchar(50)
)
AS
BEGIN TRANSACTION
INSERT INTO LoginTable VALUES(@UserId,@FName,@LName,@Email)
INSERT INTO DeptTable
VALUES(@UserId,@DepartmentName)
IF @@ERROR<>0
BEGIN
ROLLBACK
RAISERROR('ERROR IN REGISTRATION',16,1)
RETURN
END
COMMIT
GO
/******Stored Procedure for MS Sql Ends Here*******/
I need it to convert into MySql. How I Can do it , Please Help me.
Thanks in Advance
Manoj
