Re: Uploading image type using TSQL
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 26 Oct 2007 21:34:09 +0000 (UTC)
Artie (artie2269@xxxxxxxxx) 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@xxxxxxxxxxxxx
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
.
- References:
- Uploading image type using TSQL
- From: Artie
- Uploading image type using TSQL
- Prev by Date: Re: SQL Server 2005 SP2 update 2 rollup Performance tank
- Next by Date: Re: Get value from query to update another another table
- Previous by thread: Uploading image type using TSQL
- Index(es):
Relevant Pages
|
