Posted by Jack Vamvas on 03/07/06 15:44

Use WRITETEXT/READTEXT instead of INSERT/SELECT to store / retrieve
There is quite a detailed explanation in Books Online


--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm


"satish" <satishkumar.gourabathina@gmail.com> wrote in message
news:1141732028.000941.183610@e56g2000cwe.googlegroups.com...
> hi,
> i have inserted the image present in mydocuments using alter command
>
> create table aa(a int, d image)
> insert into aa values (1,'F:\prudhvi\baba 002.jpg')
>
>
> when i do
> select * from aa
> i am getting the result in the column d as
> 0x463A5C707275646876695C70727564687669203030322E6A7067
>
>
> how i can i view the image?
>
>
> pls clarify my doubt
>
>
> satish
>

[Back to original message]