MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Need Help converting Stored Procedure
Posted by: Roland Bouman
Date: November 05, 2005 07:43AM

delimiter //

CREATE function sp_InsertNewCamper
p_FirstName VarChar(30),
p_LastName VarChar(30),
p_UserName VarChar(30),
p_Password VarChar(30)
returns int unsigned
INSERT INTO Campers (FirstName, LastName, UserName, Password)
VALUES (p_FirstName, p_LastName, p_UserName, p_Password);
return last_insert_id()

should do for most of it, but you must be carful for a bit. In your example, you use NVARCHAR wich is for the national character set. look for character set support in the mysq reference for details.

Edited 1 time(s). Last edit at 11/05/2005 07:45AM by Roland Bouman.

Options: ReplyQuote

Written By
Re: Need Help converting Stored Procedure
November 05, 2005 07:43AM

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.