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: )

871 reads

Blogs

Daily Coping 5 Aug 2021

By

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

Interview Tip: Know your resume

By

Seriously. Make a point of reading your resume before submitting it, and again before...

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Read the latest Blogs

Forums

Update table from other tables

By jamesstirling01

Hi, Basically i have 2 tables check-in and check-out where users check-in and check-out...

private messages gone

By frederico_fonseca

hi, Maybe I'm doing something wrong now, but it seems that the option to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers