skip to main
|
skip to sidebar
Azeem
Thursday, November 25, 2010
Inserting a file into filestream column using OPENROWSET SQL function
INSERT INTO [tblFile]([file] ,[RowGuid])
SELECT CONVERT(varbinary(max) , Document.bulkcolumn), NEWID()
FROM OPENROWSET(BULK N'\\FilePath\File' ,SINGLE_BLOB) AS Document
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Followers
Blog Archive
►
2017
(1)
►
May
(1)
►
2013
(6)
►
November
(1)
►
August
(1)
►
July
(1)
►
May
(1)
►
April
(1)
►
March
(1)
►
2012
(2)
►
October
(1)
►
May
(1)
►
2011
(5)
►
August
(3)
►
April
(1)
►
March
(1)
▼
2010
(2)
►
December
(1)
▼
November
(1)
Inserting a file into filestream column using OPEN...
►
2009
(3)
►
November
(1)
►
May
(2)
About Me
Azeem
Malmö, Skåne, Sweden
A software developer.. working to make myself better person and programmer.
View my complete profile