Sunday, March 11, 2012

SQL Server 2008 store image into table column

For data in specific tables I will need to generate images, those images will have to be printed or displayed by various different applications.
First of all I need to store the image.
To store an image in a tablecolumn on SQL Server 2008, the manual advises to use the varbinary(MAX) type and not the image data type.
Store the image with a SQL server statement
OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability. 
The bulk provider keyword needs to be SINGLE_BLOB, which reads a file as varbinary(max).
The path to the image file is a path that the SQL Server needs to be able to read, do not confuse it with the path that an app can read, i.e. if you execute the statement from SSMS on your PC then the path E: will be a drive on the server not on your PC.
The SQL server statement to insert an image is

INSERT INTO dbo.MyTable (Id,Name,LocationPicture,)
SELECT 1,N'NameOfidentity',BulkColumn
FROM Openrowset( Bulk 'E:\ImportBarcode\000014.jpg', SINGLE_BLOB) as A 
This will result in one new row being added to the table dbo.MyTable.


3 comments:

Unknown said...

louis vuitton outlet, sac longchamp, ralph lauren pas cher, replica watches, louboutin outlet, louboutin shoes, christian louboutin outlet, prada outlet, ugg boots, longchamp pas cher, tiffany and co, louis vuitton, louboutin, air jordan pas cher, tory burch outlet, cheap oakley sunglasses, nike outlet, polo ralph lauren outlet, ray ban sunglasses, polo ralph lauren outlet, louis vuitton outlet, nike air max, replica watches, louis vuitton, air max, longchamp outlet, michael kors, oakley sunglasses, chanel handbags, nike free, nike roshe run, oakley sunglasses, burberry, tiffany jewelry, ray ban sunglasses, kate spade outlet, prada handbags, oakley sunglasses, nike air max, louis vuitton, louboutin pas cher, uggs on sale, ray ban sunglasses, oakley sunglasses, longchamp, jordan shoes, gucci outlet, ugg boots, nike free, longchamp outlet

Unknown said...

lancel, celine handbags, jimmy choo shoes, bottega veneta, nike roshe, asics running shoes, gucci, giuseppe zanotti, nike huarache, mcm handbags, herve leger, hollister, hollister, new balance, ray ban, p90x workout, soccer shoes, babyliss, longchamp, mac cosmetics, nike trainers, chi flat iron, mont blanc, vans, vans shoes, ghd, iphone cases, nike air max, hollister, ferragamo shoes, ralph lauren, louboutin, nike air max, beats by dre, valentino shoes, converse outlet, lululemon, north face outlet, instyler, soccer jerseys, birkin bag, insanity workout, baseball bats, north face outlet, abercrombie and fitch, timberland boots, reebok shoes, nfl jerseys, oakley, wedding dresses

Unknown said...

hollister, louis vuitton, canada goose outlet, moncler, pandora jewelry, swarovski, louis vuitton, bottes ugg, coach outlet, moncler, supra shoes, montre pas cher, moncler, ugg,uggs,uggs canada, ugg,ugg australia,ugg italia, canada goose, links of london, pandora jewelry, karen millen, doudoune canada goose, juicy couture outlet, moncler, pandora charms, marc jacobs, swarovski crystal, moncler, ugg pas cher, thomas sabo, louis vuitton, moncler outlet, moncler, canada goose, canada goose uk, canada goose outlet, ugg boots uk, juicy couture outlet, wedding dresses, moncler, canada goose, toms shoes, louis vuitton, replica watches, sac louis vuitton pas cher, pandora charms, canada goose