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.

You rated this post out of 5. Change rating

2004-09-16 (first published: )

916 reads

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

Error message in launching web service url in sql report server

By Teewhy

I am getting the following error when I launch web service url in sql...

Report server login issue

By Teewhy

Trying to deploy reports in visual studio 2022, reporting service login is asking for...

Opening and closing with date filter is not giving me correctly output

By akhterhussain80

I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value will be...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers