Images In Sql Server

Hi all,
How to store and retrive images in sql server ?
Thanks & Regards,
Selva Balaji B.You can use ADO with STREAM or GETCHUNK methods see these 2 articles.
HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object (Q258038) (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q258038)

Tired of FileSystemObject? Use the Stream Object Instead! (http://www.4guysfromrolla.com/webtech/083100-1.shtml)

Image Date Types

Hi,
Can any one tell me how to change an existing
Image column in a table to binary type. I am looking at
the T-SQL .
Thanks and Regards,
SajeevCREATE TABLE Tmp_myImageTable ( imagefield binary(1000) )
GO
EXEC ('INSERT INTO Tmp_testimage (im)
SELECT CONVERT(binary(1000), imagefield) FROM myImageTable ')
GO
DROP TABLE myImageTable
GO
EXECUTE sp_rename N'Tmp_myImageTable', N'myImagetable', 'OBJECT'
GO
Nathan H.O.