SoftadminGuide.ParseParameter_Columns
Type:
Table-valued function
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.