作者在 2010-12-15 09:35:13 发布以下内容
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROC [dbo].[P_LoginLyh]
@UserName varchar(500)='',
@Pwd varchar(500)=''
as
select isnull(姓名,'') as 姓名 ,isnull(角色,'') as 角色,[id]
from T_User where 用户名=@UserName and 密码=@Pwd
set QUOTED_IDENTIFIER ON
go
ALTER PROC [dbo].[P_LoginLyh]
@UserName varchar(500)='',
@Pwd varchar(500)=''
as
select isnull(姓名,'') as 姓名 ,isnull(角色,'') as 角色,[id]
from T_User where 用户名=@UserName and 密码=@Pwd