Type:
Scalar function
Return value: nvarchar(max)
A default value query for a parameter created using [SoftadminGuide.Parameter_Columns_Create].
Parameters
@ParameterNameTable
mandatory
varchar(600)
Name of a control created using SoftadminGuide.Parameter_Table_Create.
@Type
mandatory
varchar(100)
Type of column to use as default value.
| Possible value | Description |
|---|---|
| All | All columns. |
| PK | Primary key columns. |
@CustomWhere
mandatory
nvarchar(max)
Custom where statement. May refer to these aliases:
C = sys.columns
TY = sys.types
C = sys.columns
TY = sys.types