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

881 reads

Blogs

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Daily Coping 18 May 2022

By

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

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Read the latest Blogs

Forums

Quick Question on 2019 to older version?

By oogibah

A client of ours is upgrading their database to SQL Server 2019. The edition...

Mapping network drive to SSMS

By pols

Hi, I need to perform backup and save it in network drive. I have...

Extended Events to capture the queries run against the changed tracking tables.

By SQL_Hunt

Hello Group, Do you have any available extended events to capture the queries run...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers