{{theTime}}

Search This Blog

Total Pageviews

How to convert text to columns in Microsoft Excel?

 Load the text file in Excel.  Click "Data"-->"Text to Columns" and follow the steps

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...