Posted by Erland Sommarskog on 07/07/06 22:08

natzol (nataliaz@thehumanequation.com) writes:
> Is there a way to run query, make file out of query (txt,csv or xls -
> for example) and save it as a blob into the table column type
> Image/Text?

If you are on SQL 2005 you can create an XML document and save it a
column of the xml datatype or possibly nvarchar(MAX). (Don't use
image/text on SQL 2005 in new code, as these types have been deprecated.)

On SQL 2000, the answer is no.

If you describe the real business problem, we might be able to provide
alternate solutions.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Need More SQL Query NewID Help
• Prev in forum: Re: Northwind database extra SQL needs
• Thread view: Re: Make and save a blob on the fly in stored proc

[Reply to this message]