spNetAccount_Search
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@DisplayName | nvarchar(255) | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spNetAccount_Search]
(
@DisplayName nvarchar(255)
)
AS
SELECT
ID
FROM [NetAccount]
WHERE DisplayName LIKE '%' + @DisplayName + '%'
AND Deleted = 0
RETURN