Script to generate BCP Statements for a Database

The Script below creates a Stored Procedure that returns a Macro SQL Statement. When this SQL statement is executed, it inturn returns BCP Out Statements for all the tables in a given database. The database name should be passed as a parameter to the procedure. Before the procedure is created, the SA Password must be […]

1 (1)

2002-01-07

3,610 reads

Blogs

Daily Coping 3 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

[Video] Azure SQL Database – Import a Database

By

Quick Video showing you have to use a BACPAC to “import” a database into...

Read the latest Blogs

Forums

Inflow / outflow report per day

By milo1981

Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...

If SQL Agent Job takes longer than @X minutes, get notified.

By VoldemarG

If Agent Job takes longer than @X minutes, we want to be notified.  What...

Unable to create report in VS 2017

By DaveBriCam

I have downloaded and installed Visual Studio 2017 and can connect to SQL Server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers