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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:32 AM
Points: 4,023, Visits: 5,323
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