摘要： CREATE PROC P_TEST@Name VARCHAR(20),@Rowcount INT OUTPUTASBEGINSELECT * FROM T_Customer WHERE NAME=@NameSET @Rowcount=@@ROWCOUNTENDGO-------------------------------------------------------------------... 阅读全文

摘要： /** VerifyUser 存储过程* 用途：验证用户登陆*/CREATE PROCEDURE VerifyUser(@myVerifyReader int OUTPUT, --返回结果@username varchar(50), --用户名@userpassword varchar(50) --用户密码)ASIF EXISTS(SELECT [id] FROM [Users] WHERE us... 阅读全文