SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Zach Nichter

SQLServerCentral.com profile

   Items 1 to 1 of 1   

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.   Read more...
By Zach Nichter 2006/11/10 (first published: 2005/02/07) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 34,171 reads
   Items 1 to 1 of 1