SoftadminGuide.Generate_NewEdit_InsertUpdate_Sql

Type: Stored procedure

Creates the InsertUpdate procedure for a NewEdit menuitem.
Expects the temp table

CREATE TABLE #InsertUpdateColumns
(
	ColumnName sysname NOT NULL,
	DataType nvarchar(160) NOT NULL,
	SortOrder int NULL
);

The table may be created from SoftadminGuide.Table_AllColumns or SoftadminGuide.ParseField_Columns (assuming it does not involve any joins). See the documentation of those functions for further explaination of the columns.

Parameters

@OverwriteProcedure mandatory bit
Whether or not it is allowed to overwrite an existing procedure.
@ProcedureName mandatory varchar(600)
Name of the created procedure.
@TableName mandatory nvarchar(600)
Name of the table to base the procedure on.