Technical Article

BulkExport - export data from TSQL

sp_BulkExport:Export Data from TSQL without using xp_cmdshell - uses SQLDMO and sp_OA*.  Supports a variety of formats and options.  In my testing on a 22 million-row table it is NOT as fast as BCP.  This is the first rev of the proc and it has not been thoroughly tested.

2004-09-16 (first published: )

875 reads

Blogs

Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Get SQL Server 2022 Now: It’s Called Azure

By

If you’re like me, your palms went into a cold sweat to get your...

Daily Coping 29 Nov 2021

By

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

Read the latest Blogs

Forums

Help with SQL Query

By Hogie503

Hello SQL experts, Please see attached file for table detail. I have a temp...

Retry SQLAgent Job

By MrBen

Hello. Does anyone know how I can retry a job should any one of...

Get Summary Data for Last 52 weeks by Week

By skb 44459

I have a table which stores shipment data by date. We have a need...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers