Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

image insert into SQL DB Expand / Collapse
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

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



Group: General Forum Members
Last Login: Wednesday, October 5, 2016 12:14 AM
Points: 5,281, Visits: 7,008
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,

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