Posted by Artie on 10/26/07 20:12

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

Thanks.

[Back to original message]