7-26.sql

来自「asp开发 asp开发 asp开发 asp开发」· SQL 代码 · 共 9 行

--创建存储过程
CREATE PROCEDURE sp_CheckPass
(@CHKName VARCHAR(30),@CHKPass VARCHAR(30),@ISValid varCHAR(12) OUTPUT)
AS
IF EXISTS(SELECT UserName FROM WebUsers WHERE UserName=@CHKName AND UserPass= @CHKPass)
   SELECT @ISValid='Good'
ELSE
   SELECT @ISValid='Bad'