Uploading image type using TSQL
- From: "Artie" <artie2269@xxxxxxxxx>
- Date: Fri, 26 Oct 2007 13:12:10 -0700
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.
.
- Follow-Ups:
- Re: Uploading image type using TSQL
- From: Erland Sommarskog
- Re: Uploading image type using TSQL
- Prev by Date: Get value from query to update another another table
- Next by Date: Re: Weird speed problem
- Previous by thread: Get value from query to update another another table
- Next by thread: Re: Uploading image type using TSQL
- Index(es):