Posted by Erland Sommarskog on 10/26/07 21:34

Artie (artie2269@yahoo.com) writes:
> I have searched for how to upload image data types using just TSQL and
> cannot find anything. I do find examples using VBA or ASP but nothing
> based on just TSQL. Does anyone know if this is possible. Using SQL
> 2000. Example: I have a Word doc that I want to store in my database.
> How can I take a file from the Windows file system such as
> 'C:\Temp\Mydoc.doc' and upload it?
>
> CREATE TABLE [DocArchive] (
> [DocID] [int] IDENTITY (1, 1) NOT NULL ,
> [CreatedDate] [datetime] NOT NULL DEFAULT (getdate()),
> [Subject] [varchar] (256) NOT NULL ,
> [Category] [char] (30) NULL ,
> [SubCategory] [char] (30) NULL ,
> [Filename] [varchar] (100)NULL ,
> [Document] [image] NULL
> )
> GO

SQL Server is a server application, and the idea is that data will come
from clients and be sent to them.

What you can do is to use the BULK INSERT command and load the image
into a one-column table, and the copy the contents to the real table
column.

Keep in mind that the file path is related to the SQL Server
machine. If you run application and SQL Server on the same machine,
this is not an issue, but if you run SQL Server on a separate machine,
and want SQL Server to load a file from your workstation, you will
need to use a UNC path.

Also, keep in mind that if you put this in an application, that the
user must be in the bulkadmin fixed server role to have permission
to run BULK INSERT.


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

[Back to original message]