CREATE PROCEDURE right_user
@Usr as varchar(20),--用户名
@pwd varchar(20),--密码
@stringconnect varchar(4000)=''
as
declare @type int
select @type=type from 登陆表 where User=@Usr and Pwd=@Pwd
if @type is null
begin
RAISERROR ('你输入的用户名或密码不对',16, 1)
return -1
end
if @type=1
begin
set @stringconnect='driver={SQL Server};server=IP;uid=USR02;pwd=PWD02;database=DBNAME'
return 0
end
if @type=2
begin
set @stringconnect='driver={SQL Server};server=IP;uid=USR03;pwd=PWD03;database=DBNAME'
return 0
end
....
存储过程验证用户登陆信息
CREATE PROCEDURE Temp_T(@User as varchar(100),@Pwr varchar(100))
as
if Exists(select 1 from 登陆表 where User=@User and Pwr=@Pwr)
RETURN 0
else
RETURN -1