2020-03-03
491 reads
BCP (Bulk Copy Program)
Dynamic sql for convert SQL statement to txt/csv file
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpUnloadSelect.sql
Quick export to flat file.
Before use please enable xp_cmdshell.
2016-12-09 (first published: 2015-05-12)
2,276 reads
Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)
BULK INSERT and BCP are powerful, high performance tools for importing text files. SQL Server MVP Jeff Moden gives us several nifty tips in this introduction to BULK INSERT and BCP Format Files including "Skipping Columns" and the sequestration of bad rows while still loading all the good data.
2014-01-23
11,537 reads
Blogs
Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)
By KendraLittle
I'm not an expert on collation in SQL Server, but there are a few...
Do More, With Less
Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is...
Daily Coping 16 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Backup server
We will have backup server maintenance with the outage between 15mins to 1 hr....
Is SQL developer edition exactly the same as enterprise edition?
Hey all, Regarding licensing of SQL server, we are considering the possibility of running...
Logging (auditing) in the table vs. having a logging (auditing) table
I really like Steve Jones' editorial today, Carefully Giving Normal Users Security Permissions. I've...
Ask SSC