2
Shouts

Use Sql query to write/create a file

posted by http://prashantmx.myopenid.com/http://prashantmx.myopenid.com/ 870 days, 14 hours, 7 minutes ago
Wednesday, January 06, 2010 10:28:25 AM GMT

This SQL stored procedure will allow you to write to the file on your file system. Note the file system will be the the same on which the SQL server is running. If you are using this with your local SQL server then it will write and create files on your local file system and if you are on the remote machine, the file system will be the remote file system.Create Procedure [dbo].USP_SaveFile,@Filename Varchar(200)) AS Begin

declare @Object int, @rc int, -- the re...

category: SQL | clicked: 0 | | source: www.midnightprogrammer.net | show counter code
tags: SQL, Stored Procedure, file

No comments yet, be the first one to post comment.

To post your comment please login or signup