Skip to content

Instantly share code, notes, and snippets.

@aroder

aroder/Data Porters set to auto truncate columns.sql

Created January 10, 2017 21:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aroder/bc6301c2fe0e9cbf1d981e4316391288 to your computer and use it in GitHub Desktop.
Save aroder/bc6301c2fe0e9cbf1d981e4316391288 to your computer and use it in GitHub Desktop.
Download ZIP
Best practice for Markit EDM Data Porters is to turn off auto truncate. But the default settings turn it on. This query finds Data Porters with the setting turned on
Raw
Data Porters set to auto truncate columns.sql
SELECT DP.NAME,
m.c.value('ProcType[1]', 'varchar(max)') AS ProcType,
m.c.value('AutoTruncate[1]', 'varchar(max)') AS AutoTruncate,
m.c.value('Name[1]', 'varchar(max)') AS [Input Name]
FROM [CADIS_SYS].[DP_DATAPORT] DP
CROSS APPLY DP.[DEFINITION].nodes('CadisXml/Content/Inputs/list/Item') AS m(c)
WHERE m.c.value('AutoTruncate[1]', 'varchar(max)') = 'True'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment