作者在 2010-12-14 16:19:54 发布以下内容
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROC [dbo].[P_Loginydp]
@UserName varchar(500),
@Psd varchar(500),
@PersonName varchar(50) OUTPUT,
@PersonRole varchar(50) OUTPUT ,
@ID int OUTPUT
as
select @PersonName=姓名,@PersonRole=角色,@ID=id
from T_User where 用户名=@UserName and 密码=@Psd
set QUOTED_IDENTIFIER ON
go
ALTER PROC [dbo].[P_Loginydp]
@UserName varchar(500),
@Psd varchar(500),
@PersonName varchar(50) OUTPUT,
@PersonRole varchar(50) OUTPUT ,
@ID int OUTPUT
as
select @PersonName=姓名,@PersonRole=角色,@ID=id
from T_User where 用户名=@UserName and 密码=@Psd