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)

You rated this post out of 5. Change rating

2002-01-07

3,856 reads

Blogs

SQL Training Black Friday Deals

By

If you're looking for particular "Black Friday" deals, here is what I've seen advertised...

Dry-run xp_delete_file Before Actually Deleting Files?

By

Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...

Happy Thanksgiving! (USA Holiday)

By

In the United States, today is Thanksgiving. The intent behind the holiday is to...

Read the latest Blogs

Forums

Don't Let Corner Cases Drive Your Design

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Don't Let Corner Cases Drive...

A New Operator

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A New Operator

Troubleshooting Common SQL Server Errors: 823, and 824

By Nisarg Upadhyay

Comments posted to this topic are about the item Troubleshooting Common SQL Server Errors:...

Visit the forum

Question of the Day

A New Operator

In SQL Server 2025, what does this code return?

SELECT '1' || '0'
 

See possible answers