using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
CREATE PROC SP_User_Login
(
@name VARCHAR(15),
@pwd VARCHAR(15)
)
AS
DECLARE @temp_Name VARCHAR(15)
BEGIN
SELECT @temp_Name=UserName
FROM t_UserLogin
WHERE UserName = @name
AND
Password = @pwd
IF @temp_Name IS NOT NULL
RETURN 0 --登录成功
IF EXISTS (SELECT UserName
FROM t_UserLogin
WHERE UserName = @name)
RETURN 1 --密码不正确
ELSE
RETURN 2 --用户名不存在
END
GO