MySQL Forums
Forum List  »  Microsoft SQL Server

Need Help converting Stored Procedure
Posted by: Jesse Castleberry
Date: November 04, 2005 01:56PM

I am converting a MS SQL Server ASP application over to use MySQL. I have two simple stored procedures that I need to convert. I have very little experience with MS SQL, and none-what-so-ever with stored procedures in MySQL, so I really don't know what this should look like. I'll post the first one, and if I'm able to figure it out, I'll attempt my second one by myself. Here's the code from MS SQL:

CREATE Procedure sp_InsertNewCamper
@FirstName NVarChar(30),
@LastName NVarChar(30),
@UserName NVarChar(30),
@Password NVarChar(30)
INSERT INTO Campers (FirstName, LastName, UserName, Password)
VALUES (@FirstName, @LastName, @UserName, @Password)

return @@Identity



Options: ReplyQuote

Written By
Need Help converting Stored Procedure
November 04, 2005 01:56PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.