2020-03-03
504 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,320 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
20,348 reads
Blogs
Dynamic Data Masking – SQL Server
By Tim Radney
Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...
Using ThinOptics to Read Data
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
Forums
Be Careful with Missing Index Requests
Comments posted to this topic are about the item Be Careful with Missing Index...
GitHub Copilot - Our Best Ally to for T-SQL
Comments posted to this topic are about the item GitHub Copilot - Our Best...
Zero Statistics Sampling
Comments posted to this topic are about the item Zero Statistics Sampling
Ask SSC