7-26.sql

asp开发 asp开发 asp开发 asp开发

--创建存储过程
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'