USP_ACCOUNTINGELEMENTSECURITYGROUP_DELETE_PROMPTDATA

Provides the prompt for the "Accounting Element Security Group: Delete" record operation.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN Represents information to be displayed in the record operation prompt.
@NAME nvarchar(100) INOUT

Definition

Copy


              CREATE procedure dbo.USP_ACCOUNTINGELEMENTSECURITYGROUP_DELETE_PROMPTDATA
              (
                  @ID uniqueidentifier,
                  @NAME nvarchar(100) = null output
              )
              as begin
                  set nocount on;

                  select
                      @NAME = NAME
                  from
                      dbo.ACCOUNTINGELEMENTSECURITYGROUP
                  where
                      ID = @ID

                  return 0;
              end