Zach Nichter


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

37,917 reads

Blogs

Behavior of numeric data types with ”

By

As we all know, there are various numeric data types, such as TINYINT, INT,...

Daily Coping 5 Mar 2021

By

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

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Read the latest Blogs

Forums

Golden Goose Outlet too

By allonsalevips

Black women are constantly being policed in this way: from what we wear and...

shared datasets and cache refresh option

By ricky969

hi guys! Problem:  1) Every time I overwrite an existing shared dataset (with a...

Question on report server database

By itmasterw 60042

Hi,   We just installed SQL Server 2019 on a new server and moved...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers