workflow.Biml_Connection - V
type: V ( view ), modify_date: 2022-09-08 16:16:52
RepoObject_guid: B066A0A8-E3FA-EB11-850E-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
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