Procedures


ProcedureDescription
dbo01.uspUpdateTableFormatConfiguration Procedure to Save Table Formats
etl01.uspGenerateChangeHandlerProcedure to Generate Cell Change Handler
etl01.uspGenerateEditProceduresProcedure to Generate CRUD Procedures
etl01.uspGenerateGenegicHandlerProcedure to Generate Generic Handler
etl01.uspUpdateColumnTranslationProcedure to Insert Column Translations
etl01.uspUpdateColumnTranslation_GroupProcedure to Insert Column Group Translations
etl01.uspUpdateObjectTranslationProcedure to Insert New Schema or Language Object Translation
etl01.uspUpdateObjectTranslationAbsentProcedure to Insert New Object Translation of Existing Schema and Languages

dbo01.uspUpdateTableFormat

ParameterDataTypeModeComment
@Schemanvarchar(128)IN
@Namenvarchar(128)IN
@ExcelFormatXMLxmlIN

The procedure is used to save Excel formats of database objects

etl01.uspGenerateChangeHandler

ParameterDataTypeModeComment
@TableSchemanvarchar(128)IN
@TableNamenvarchar(128)IN
@TargetSchemanvarchar(128)IN
@ExecuteScriptbitIN

The procedure is used to generate a cell change handler.

etl01.uspGenerateEditProcedures

ParameterDataTypeModeComment
@TableSchemanvarchar(128)IN
@TableNamenvarchar(128)IN
@TargetSchemanvarchar(128)IN
@ExecuteScriptbitIN
@RecreateProceduresIfExistbitIN

The procedure is used to generate SELECT, INSERT, UPDATE and DELETE procedures.
The result code includes related tables of primary keys also.
Use SQL Server Management Studio to generate and edit the procedures.

etl01.uspGenerateGenegicHandler

ParameterDataTypeModeComment
@TableSchemanvarchar(128)IN
@TableNamenvarchar(128)IN
@TargetSchemanvarchar(128)IN
@EventNamenvarchar(128)IN
@NameSuffixnvarchar(128)IN
@ExecuteScriptbitIN

The procedure is used to generate a generic handler.

etl01.uspUpdateColumnTranslation

ParameterDataTypeModeComment
@Schemanvarchar(128)IN
@LanguageNamechar(2)IN

The procedure is used to insert new column translation data into the ColumnTranslation table.

etl01.uspUpdateColumnTranslation_Group

ParameterDataTypeModeComment
@Schemanvarchar(128)IN
@LanguageNamechar(2)IN

The procedure is used to insert new translation data for group of columns and parameters into the ColumnTranslation table.

etl01.uspUpdateObjectTranslation

ParameterDataTypeModeComment
@Schemanvarchar(128)IN
@LanguageNamechar(2)IN

The procedure is used to insert translation data for new schemas or languages into the ObjectTranslation table.

etl01.uspUpdateObjectTranslationAbsent

The procedure is used to insert translation data for new objects of existing schemas and languages into
the ObjectTranslation table. viewObjectTranslationSuggest is used as a data source.