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)

You rated this post out of 5. Change rating

2002-01-07

3,854 reads

Blogs

Prepping for Certification, Part 1 of ?

By

I thought it would be good to put my thoughts down on how to...

How to Avoid Knowledge Stagnation

By

You want the short answer? Well, the only antidote to knowledge stagnation is probably...

Demystifying Fabric Workspaces: The Nerve Center of Your Data Universe

By

It always starts the same way. You open your laptop on a Monday morning,...

Read the latest Blogs

Forums

just finished a deep dive into snowflake

By stan

Sorry, but you do not have permission to view this content.

Database File Growth Report Script

By Deepam Ghosh

Comments posted to this topic are about the item Database File Growth Report Script

SQL Server authentication vs. Trusted connection

By Rod at work

I maintain an application written years ago, where the database is on a Windows...

Visit the forum

Question of the Day

The Duplicate Cursor

Can I run this code:

DECLARE ANewTable CURSOR FOR 
SELECT * FROM ANewTable

See possible answers