Procedure | Description |
---|---|
dbo01.uspUpdateTableFormat | Configuration Procedure to Save Table Formats |
etl01.uspGenerateChangeHandler | Procedure to Generate Cell Change Handler |
etl01.uspGenerateEditProcedures | Procedure to Generate CRUD Procedures |
etl01.uspGenerateGenegicHandler | Procedure to Generate Generic Handler |
etl01.uspUpdateColumnTranslation | Procedure to Insert Column Translations |
etl01.uspUpdateColumnTranslation_Group | Procedure to Insert Column Group Translations |
etl01.uspUpdateObjectTranslation | Procedure to Insert New Schema or Language Object Translation |
etl01.uspUpdateObjectTranslationAbsent | Procedure to Insert New Object Translation of Existing Schema and Languages |
Parameter | DataType | Mode | Comment |
---|---|---|---|
@Schema | nvarchar(128) | IN | |
@Name | nvarchar(128) | IN | |
@ExcelFormatXML | xml | IN |
The procedure is used to save Excel formats of database objects
Parameter | DataType | Mode | Comment |
---|---|---|---|
@TableSchema | nvarchar(128) | IN | |
@TableName | nvarchar(128) | IN | |
@TargetSchema | nvarchar(128) | IN | |
@ExecuteScript | bit | IN |
The procedure is used to generate a cell change handler.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@TableSchema | nvarchar(128) | IN | |
@TableName | nvarchar(128) | IN | |
@TargetSchema | nvarchar(128) | IN | |
@ExecuteScript | bit | IN | |
@RecreateProceduresIfExist | bit | IN |
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.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@TableSchema | nvarchar(128) | IN | |
@TableName | nvarchar(128) | IN | |
@TargetSchema | nvarchar(128) | IN | |
@EventName | nvarchar(128) | IN | |
@NameSuffix | nvarchar(128) | IN | |
@ExecuteScript | bit | IN |
The procedure is used to generate a generic handler.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@Schema | nvarchar(128) | IN | |
@LanguageName | char(2) | IN |
The procedure is used to insert new column translation data into the ColumnTranslation table.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@Schema | nvarchar(128) | IN | |
@LanguageName | char(2) | IN |
The procedure is used to insert new translation data for group of columns and parameters into the ColumnTranslation table.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@Schema | nvarchar(128) | IN | |
@LanguageName | char(2) | IN |
The procedure is used to insert translation data for new schemas or languages into the ObjectTranslation table.
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.