USP_RECORDOPERATION_DELETEMKTMARKETINGPLANITEMPROMPT
Provides the prompt for the "Marketing Plan Item: Delete" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @CAPTION | nvarchar(150) | INOUT |
Definition
Copy
CREATE procedure dbo.[USP_RECORDOPERATION_DELETEMKTMARKETINGPLANITEMPROMPT]
(
@ID uniqueidentifier,
@CAPTION nvarchar(150) output
)
as
set nocount on;
select
@CAPTION = LOWER([NAME])
from
dbo.[MKTMARKETINGPLANITEM]
where
[MKTMARKETINGPLANITEM].[ID]= @ID;
return 0;