workflow.Biml_Connection - V

type: V ( view ), modify_date: 2022-09-08 16:16:52

RepoObject_guid: B066A0A8-E3FA-EB11-850E-A81E8446D5B0

Description

Examples

Entity Diagram

entity-workflow.biml_connection

Columns

Table 1. Columns of workflow.Biml_Connection - V
PK Column Name Data Type NULL? ID

nvarchar(max)

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-workflow.biml_connection

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.biml_connection

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.biml_connection

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.biml_connection

Column Reference Diagram

entity_1_1_colref-workflow.biml_connection

Column Details

_

ConnectionName_Biml

ConnectionName_Biml

nvarchar(max)

NULL

ConnectionString_Biml

ConnectionString_Biml

nvarchar(max)

NULL

sql_modules_definition

workflow.Biml_Connection - V script
CREATE View workflow.Biml_Connection
As
Select
    ConnectionName_Biml   = String_Agg (
                                           Cast('<Connection ConnectionName="' As NVarchar(Max)) + T1.ConnectionName
                                           + '" />'
                                         , Char ( 13 ) + Char ( 10 )
                                       ) Within Group(Order By
                                                          T1.ConnectionName)
  , ConnectionString_Biml = String_Agg (
                                           Cast('<Connection Name="' As NVarchar(Max)) + T1.ConnectionName
                                           + '" ConnectionString="' + T1.ConnectionString + '" />'
                                         , Char ( 13 ) + Char ( 10 )
                                       ) Within Group(Order By
                                                          T1.ConnectionName)
From
    workflow.Connection As T1
Where
    T1.is_active = 1