USP_DATAFORMTEMPLATE_EDUCATIONALDEGREECODEEXTENSION_PRELOAD
The load procedure used by the edit dataform template "Educational Degree 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_EDUCATIONALDEGREECODEEXTENSION_PRELOAD
(
@CODETABLENAME nvarchar(100) = null output,
@SEQUENCE int = null output
)
as
set nocount on;
set @CODETABLENAME = 'EDUCATIONALDEGREECODE';
set @SEQUENCE = -1;
if exists (select 1 from dbo.EDUCATIONALDEGREECODE)
select @SEQUENCE = max(SEQUENCE) + 1 from dbo.EDUCATIONALDEGREECODE;