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)

2006-11-10 (first published: )

40,015 reads

Blogs

Daily Coping 17 May 2022

By

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

Storage Field Day 23 – HammerSpace

By

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

Daily Coping 16 May 2022

By

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

Read the latest Blogs

Forums

can i store hashbyte on field with length smaller than fields i concatenate it?

By ahmed_elbarbary.2010

I work on sql server 2019 i have table have multi column string concatenation...

Migration of Data from one Database to Multiple Databases

By vamshi.sql

Hello, I have a requirement to migrate the data from existing AWS RDS DB...

AWS Beginner questions

By cariebens

I'm having some trouble wrapping my head around the relationship between EC2 instances and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers