Notice that first column is the column name. Once we choose “Comma delimited” and hit OK – we will get below kind of output when we eecure a query (Note that we need to open a new Query Window so that the settings are saved) Go to “Query Results” > “SQL Server” > Click on “Results to Text” Go to SQL Server Management Studio > Choose Tools from Menu Bar > Click on Options. A lot of times it is our inability to learn some of the simple techniques present in the tools that we use make us even more productive. Well, that was a strong statement and I liked the simplicity of the solution. ![]() ![]() Some blog readers reported that why we should use SQLCMD or BCP to generate the file when the same can be achieved using SQL Server Management Studio itself. In my previous blog I talked about using SQLCMD to generate a comma separate files for the table data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |