动软MySQL存储过程模板

DROP procedure IF EXISTS _GetMaxId;CREATE PROCEDURE _GetMaxId()BEGIN SELECT MAX(Id) FROM ;END;DROP procedure IF EXISTS _Exists;CREATE PROCEDURE _Exists($_Id int)BEGIN SELECT count(1) FROM WHERE Id=$_Id ;END;DROP procedure IF EXISTS _ADD;CREATE PROCEDURE _ADD( OUT $_ (),$_ $_ (),) BEGIN INSERT ...
posted @ 2014-03-07 14:20  BicycleBoy  阅读(769)  评论(0编辑  收藏  举报