skip to main
|
skip to sidebar
All sorts of IT tips, tricks, and feedback
Tuesday, May 6, 2008
Importing an image into an image column using SQL 2005
Hi
Ever had to import an image into a column ? Here is a simple Insert statement...
Insert MyLogoTable (Logo)
Select BulkColumn
from Openrowset( Bulk 'c:\SomeJPEGFile.jpg', Single_Blob) as Logo
Cheers
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2015
(1)
►
December
(1)
►
2014
(7)
►
December
(1)
►
November
(1)
►
October
(4)
►
August
(1)
►
2013
(1)
►
October
(1)
►
2012
(1)
►
September
(1)
►
2011
(1)
►
September
(1)
►
2010
(2)
►
February
(1)
►
January
(1)
►
2009
(4)
►
August
(1)
►
June
(3)
▼
2008
(8)
►
August
(1)
►
July
(1)
▼
May
(4)
Shrink inactive database log files
Dynamic MetaData Reader
Dynamic Info Matrix
Importing an image into an image column using SQL ...
►
April
(1)
►
January
(1)
►
2007
(2)
►
November
(2)
What is Best Practice ?
About Me
Zanoni Labuschagne
Being in IT for more than 15 years, I have seen things come and go. Somehow (after years developing in various industries and using numerous technologies), I have ended up in the BI / Warehouse arena, and dare I say it, I am a big Ralph Kimball fan
View my complete profile
No comments:
Post a Comment