USP_PROJECT_DELETE_PROMPTDATA
Provides the prompt for the "Project: Delete" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @ELEMENTNAME | nvarchar(100) | INOUT | |
| @ELEMENTID | nvarchar(100) | INOUT |
Definition
Copy
CREATE procedure dbo.USP_PROJECT_DELETE_PROMPTDATA
(
@ID uniqueidentifier,
@ELEMENTNAME nvarchar(100) = null output,
@ELEMENTID nvarchar(100) = null output
)
as begin
set nocount on;
select
@ELEMENTNAME = ELEMENTNAME,
@ELEMENTID = SHORTDESCRIPTION
from
dbo.PDACCOUNTSEGMENTVALUE
where
ID = @ID
return 0;
end