Browsing articles in "SQL Server"

SQL Server – Export All User Tables Part 1


If all you want is to export raw data from SQL server to a flat file, doing so should be easy. But what if you require text qualifiers and a formatted header? Neither BCP or SQLCMD support text qualifiers. BCP doesn’t support column headers at all and SQLCMD’s column headers aren’t very friendly. So what do you do when you need to dump all the data in your database to flat files? If you only […]