| 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 Procedures | David Anderson | 23 Dec |
| • Re: Stored Procedures | Jesse | 26 Dec |
