spGetUserIDFromEmailAddress
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| nchar | IN |
Definition
Copy
CREATE procedure [dbo].[spGetUserIDFromEmailAddress](@Email nchar(100))
as
select [ID], [UserName], [FirstName], [LastName] from dbo.ClientUsers cu
where cu.Email = @Email
and cu.deleted = 0