Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

image insert into SQL DB Expand / Collapse
Author
Message
Posted Sunday, September 9, 2012 10:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 9, 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
Posted Monday, September 10, 2012 4:10 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:47 AM
Points: 3,855, Visits: 4,994
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 »

Add to briefcase

Permissions Expand / Collapse