... each column type is DT_STR/DT_WSTR
for (int x = 0; x < input.InputColumnCollection.Count; x++)
{
if (!(input.InputColumnCollection[x].DataType == DataType.DT_STR
...
... AS [DB1_ColumnMaxLength],
t2.CHARACTER_MAXIMUM_LENGTH AS [DB2_ColumnMaxLength],
t1.COLLATION_NAME AS [DB1_ColumnCollation],
t2.COLLATION_NAME AS [DB2_ColumnCollation]
FROM [myDB1].[INFORMATION_SCHEMA].[COLUMNS] ...
... going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format of [h]:mm:ss
-- Aim / Objective:
ColumnA ColumnB ColumnC
---------- ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.