How to Save, Reterive and Display Photo...?

[jawan]

How we can save and display picture from Table...?
If we see table employees in DB Northwind, there is one field Photo in that table which has information in binary, how to convert that info and how to display pic.....?

What is the best way to save, reterieve and display a picture....?

Thanks

 

[MartinCroft]

Hi

there is a facility in SQL called textcopy which is a program where the default lcoation is

C:\Program Files\Microsoft SQL Server\MSSQL\Binn
if you type textcopy/?

at a dos prompt you will get all the syntax

the basic description of it is

Copies a single text or image value into or out of SQL Server. The value
is a specified text or image 'column' of a single row (specified by the
"where clause") of the specified 'table'.

hope thats of some help

Mysticmart

 

[jawan]

Thanks for reply, i am confused

let's say i have picture ABC.JPG, i want save in a field (table), who i can do this....?

Thanks