Zach Nichter


SQLServerCentral Article

Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

SQL Server has extensions to allow one to call COM based objects from within the server using T-SQL. While this is an interesting feature, it's may not be the best way to structure your applications due to performance reasons. New author Zach Nichter of ScalabilityExperts.com brings us an analysis of different ways of writing out to a file from within SQL Server. Read on to see the most efficient method of generating files on your server.

5 (2)

You rated this post out of 5. Change rating

2006-11-10 (first published: )

42,912 reads

Blogs

THAT Conference 2024 in Wisconsin Dells

By

I’m headed back to Wisconsin Dells next week for THAT! Conference 2024. This is...

7 Best Online Advanced SQL Training Courses to Learn in 2024

By

The world runs on data, and SQL is the key to unlocking its secrets....

Calling a REST Endpoint from Azure SQL DB

By

External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas...

Read the latest Blogs

Forums

Thinking About Technology

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thinking About Technology

SQL Server on Linux Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server on Linux Restrictions

Error fetching data via Linked Server

By Ram

Hi, SS ver: SS 2017, SE; Oracle: 19.23 SE We have a nightly job...

Visit the forum

Question of the Day

SQL Server on Linux Restrictions

Which of these features are not available on SQL Server on Linux? (choose 2)

See possible answers