1.在mssql创建存储过程,在db->存储过程->新建存储过程(右键)
CREATE PROCEDURE user_logon_check @username varchar(45),@userpsw varchar(45)
AS
select * from users where UserName = @username and PasswordCode = @userpsw
return 10
GO
2.在mysql创建存储过程,使用Mysql Query Browser,在db->表名->Create New Procedure/Function(右键)
DELIMITER //
DROP PROCEDURE IF EXISTS `test`.`user_logon_check`//
CREATE PROCEDURE `user_logon_check`(in username varchar(45),IN userpsw varchar(45))
BEGIN
SELECT * FROM test where name = username and psw = userpsw;
END//
DELIMITER ;
注意将 $$ -> //