Technical Article

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,808 reads

Blogs

Why i use a smaller docker image part I

By

What is Docker? Docker is a famous platform for building, shipping, and running container...

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

Read the latest Blogs

Forums

script to find the frequent used login information in the sql

By pols

Hi, Kindly some one share the script or query to get the login information...

SQL Server Agent is not expanding and Jobs are not visible

By pols

Hi, We are not able to expand the SQL SERVER Agent. It is taking...

Seperator after value

By Markus712

Hi, I need to insert a separator after each value but I don't want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers