how to insert a picture into Ms. SQL server

Dear all,
I wonder how I can insert a picture into Ms.SQL server 2005? I can insert datas and read it with select sentence.. with ASP
Please consider that I don't have Ms. SQL server on my computer, it is on the server and I am inserting the datas with ASP.
and I wonder how to read it too.

Could you please give me an example,
best regards
omercinarogluAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
matrix_aashConnect With a Mentor Commented:
Hi,

First of all inserting pictures into SQL Server 2005 table will take lot of space and will also degarde the performace of your db.

The best way to proceed is  save the reference path(URL) of the picture and save the picture on the local disk.

this way the db wont be of massive size and the performance will also be good.

Please let me know if this helps

Cheers,

Aash.
0
 
brejkCommented:
INSERT INTO MyTable (MyImageColumn)
SELECT * FROM OPENROWSET (BULK N'C:\MyPicture.bmp', SINGLE_BLOB)
0
 
omercinarogluAuthor Commented:
Excellent
0
 
omercinarogluAuthor Commented:
I thank both of you
0
All Courses

From novice to tech pro — start learning today.