You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
14 lines
468 B
14 lines
468 B
2 weeks ago
|
|
||
|
drop proc GetUserInfoByUserEmail_Select
|
||
|
|
||
|
create proc GetUserInfoByUserEmail_Select
|
||
|
|
||
|
@UserEmail nvarchar(30)
|
||
|
|
||
|
as
|
||
|
|
||
|
select CusID as UserID, CusEmail as UserEmail, CusRealName as UserName, CusSex as UserSex,CusPostCode as UserPostCode,CusRegDate as UserRegDate,CusAddress as UserAddress,CusTel as UserTel,CusMd5 as UserMd5,CusIsActive as ValidateNum from dbo.Customer where CusEmail = @UserEmail and CusIsDeleted =1
|
||
|
|
||
|
|
||
|
GetUserInfoByUserEmail_Select "tangdunfeng@sina.com"
|