Name spaces to include: using System; using System.Text; using System.Threading; ---------------------------------------------- Progress bar class: class progressBar { /// <summary> /// An ASCII progress bar /// </summary> public class ProgressBar : IDisposable, IProgress<double> { private const int blockCount = 40; private readonly TimeSpan animationInterval = TimeSpan.FromSeconds(1.0 / 8); private const string animation = @"▀▀▀▀▄▄▄▄";//@"▀▀▀▀▄▄▄▄" @"|/-\"; ...
Run the following sql query for each database. SELECT ST.NAME 'TABLE' , SC.NAME 'COLUMN' , T.NAME 'COLUMN TYPE' ,SC.MAX_LENGTH 'LENGTH', SC.is_nullable ,object_definition(SC.default_ object_id) AS defaultVal FROM SYS.TABLES ST INNER JOIN SYS.COLUMNS SC ON ST.OBJECT_ID = SC.OBJECT_ID INNER JOIN SYS.TYPES T ON SC.SYSTEM_TYPE_ID = T.SYSTEM_TYPE_ID AND SC.SYSTEM_TYPE_ID = T.USER_TYPE_ID LEFT JOIN SYS.EXTENDED_PROPERTIES EX ON EX.MINOR_ID = SC.COLUMN_ID AND EX.MAJOR_ID = ST.OBJECT_ID order by ST.NAME , SC.NAME Save the outputs as .CSV files. Build an EXE file for the following code. Put the two CSV files and the exe file in a folder Run ...
Comments
Post a Comment