USP_DATAFORMTEMPLATE_EDUCATIONALSUBDEPARTMENTCODEEXTENSION_PRELOAD
The load procedure used by the edit dataform template "Educational Sub Department Code Extension Add Data Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CODETABLENAME | nvarchar(100) | INOUT | Code table name |
| @SEQUENCE | int | INOUT | Sequence |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDUCATIONALSUBDEPARTMENTCODEEXTENSION_PRELOAD
(
@CODETABLENAME nvarchar(100) = null output,
@SEQUENCE int = null output
)
as
set nocount on;
set @CODETABLENAME = 'EDUCATIONALSUBDEPARTMENTCODE';
set @SEQUENCE = -1;
if exists (select 1 from dbo.EDUCATIONALSUBDEPARTMENTCODE)
select @SEQUENCE = max(SEQUENCE) + 1 from dbo.EDUCATIONALSUBDEPARTMENTCODE;