USP_CONSTITUENCYDEFINITION_MARKINACTIVE_PROMPT
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @DESCRIPTION | nvarchar(100) | INOUT |
Definition
Copy
create procedure USP_CONSTITUENCYDEFINITION_MARKINACTIVE_PROMPT
(
@ID uniqueidentifier,
@DESCRIPTION nvarchar(100) output
)
as
set nocount on;
select
@DESCRIPTION = CONSTITUENCYDEFINITION.DESCRIPTION
from
dbo.CONSTITUENCYDEFINITION
where
CONSTITUENCYDEFINITION.ID = @ID