image insert into SQL DB

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » image insert into SQL DB

image insert into SQL DB

Rate Topic

Display Mode

Topic Options

Author

Message

IMDB

Posted Sunday, September 09, 2012 10:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, September 09, 2012 1:43 PM
Points: 1, Visits: 13

Hi,

What I have to do is creating a SQL image DB but instead of inserting the images themselves into it I have to refer the image location (the images are stored on the local disc).
Does anybody know how this can be done?

Post #1356492

Stewart "Arturius" Campbell

Posted Monday, September 10, 2012 4:10 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 8:31 AM
Points: 3,129, Visits: 4,312

Enable FILESTREAM in your database;
Ensure your column is of VARBINARY(MAX) datatype, with FILESTREAM storage type, e.g.

CREATE TABLE Archive.dbo.Records
(
	[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE, 
	[SerialNumber] INTEGER UNIQUE,
	[Chart] VARBINARY(MAX) FILESTREAM NULL
)
GO

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1356627

« Prev Topic | Next Topic »

Permissions