2 messages in com.mysql.lists.dotnetStored Procedures
FromSent OnAttachments
David Anderson23 Dec 2005 12:12 
Jesse26 Dec 2005 11:55 
Subject:Stored Procedures
From:David Anderson (dav@dmaassociates.co.uk)
Date:12/23/2005 12:12:01 PM
List:com.mysql.lists.dotnet

Hello All,

I am trying to get my head around stored procedures.

I have an SP as follows: DELIMITER $$;

DROP PROCEDURE IF EXISTS `pnetinno`.`GetLast`$$

CREATE PROCEDURE `GetLast`(OUT maxid INT) BEGIN select maxid = max(id)from rawreviews; END$$

DELIMITER ;$$

How do I write the code (in VB or C#) to get the value of maxid?