set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROC [dbo].[P_LoginLyh]@UserName varchar(500)='', @Pwd varchar(500)=''asselect isnull(姓名,'') as 姓名 ,isnull(角色,'') as 角色,[id] from T_User where 用户名=@UserName and 密码=@Pwd

set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROC [dbo].[P_Loginydp]@UserName varchar(500),@Psd varchar(500),@PersonName varchar(50) OUTPUT,@PersonRole varchar(50) OUTPUT ,@ID int OUTPUTasselect @PersonName=姓名,@PersonRole=角色,@ID=id from T_User where 用户名=@UserName and 密码=@Psd