List:MySQL and .NET« Previous MessageNext Message »
From:David Anderson Date:December 23 2005 8:12pm
Subject:Stored Procedures
View as plain text  
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?
  

-- 
Best regards,
 David                          mailto:david@stripped


Thread
Stored ProceduresDavid Anderson23 Dec
  • Re: Stored ProceduresJesse26 Dec