Photo Result Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Photo Result Error

Author

Topic

wkalo
Starting Member

10 Posts

Posted - 2011-05-30 : 03:55:52

Hi There
I created a table as follows

CREATE TABLE [dbo].[stockGifs](
[StockGifID] [int] NOT NULL,
[Gif] [varbinary](max) NULL
) ON [PRIMARY]

I Have Inserted A Photo Using The Following Syntax

insert stockGifs
(StockGifID, Gif)
Select 3, BulkColumn
From Openrowset ( Bulk 'C:\Folder1\SubFolder1\Photo-0017.jpg', Single_blob) as X

On The select Statement I Get An Empty Field
If I Open The Table In The Image Field I See <Binary Data>

What Seems To Be The Trouble ????
Any Help Please ???

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-05-30 : 05:44:03

You can't view an image in the Server. It should be done using a front end application

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources