SoftadminGuide.ParseParameter_Columns

Type: Table-valued function

Parses the values from a parameter created by SoftadminGuide.Parameter_Columns_Create.

Parameters

@ColumnsParameter mandatory nvarchar(max)
The value of the parameter.

Resultsets

Resultset: Columns

Table count:
Row count:
Columns
Id mandatory any
A unique id, used to map the columns to the correct table.

May join on the Id column of any SoftadminGuide.ParseParameter-object, and the value of a parameter created with SoftadminGuide.Parameter_Table_Create.
ColumnName mandatory string
The name of the database column.
ColumnId mandatory int
The ColumnId from sys.columns.
DataType mandatory string
The data type Name from sys.types.
SortOrder mandatory int
The sort order, first ordered by the join order for tables and secondary by the ColumnId.