docs.ssis_SqlTaskParameterInnerTable - V

type: V ( view ), modify_date: 2021-11-07 00:11:53

RepoObject_guid: BBDCAD7F-F73E-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.ssis_sqltaskparameterinnertable

Columns

Table 1. Columns of docs.ssis_SqlTaskParameterInnerTable - V
PK Column Name Data Type NULL? ID

varchar(50)

NOT NULL

varchar(200)

NOT NULL

nvarchar(max)

NOT NULL

varchar(8000)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssis_sqltaskparameterinnertable

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssis_sqltaskparameterinnertable

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssis_sqltaskparameterinnertable

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssis_sqltaskparameterinnertable

Column Reference Diagram

entity_1_1_colref-docs.ssis_sqltaskparameterinnertable

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL

PackageName

PackageName

varchar(200)

NOT NULL

SqlTaskParameterInnerTable

SqlTaskParameterInnerTable

nvarchar(max)

NOT NULL

TaskPath

TaskPath

varchar(8000)

NOT NULL

sql_modules_definition

docs.ssis_SqlTaskParameterInnerTable - V script
CREATE View docs.ssis_SqlTaskParameterInnerTable
As
Select
    T1.AntoraModule
  , T1.PackageName
  , T1.TaskPath
  , SqlTaskParameterInnerTable =
  --
  Concat (
             Cast(N'' As NVarchar(Max))
           , Char ( 13 ) + Char ( 10 )

           --table start
           , '[cols="1l,1l"]' + Char ( 13 ) + Char ( 10 )
           --, '[cols="1l,1l,1l"]' + Char ( 13 ) + Char ( 10 )
           , '!===' + Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )

           --table content
           , String_Agg (
                            Concat (
                                       Cast(N'' As NVarchar(Max))
                                     , '!' + T1.ParameterBindingSequence + Char ( 13 ) + Char ( 10 )
                                     , '!' + IsNull ( T1.ParameterBindingParameterName, '' ) + Char ( 13 )
                                       + Char ( 10 )
                                   ----use this, if we have ssis examples containing ResultSetParameterName
                                   --, '!' + IsNull ( T1.ResultSetParameterName, '' ) + Char ( 13 ) + Char ( 10 )
                                   )
                          , Char ( 13 ) + Char ( 10 )
                        ) Within Group(Order By
                                           T1.ParameterBindingSequence)

           --table end
           , '!===' + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
         )
From
    ssis.PackageTask_Sql_Parameter As T1
Group By
    T1.AntoraModule
  , T1.PackageName
  , T1.TaskPath