Image to SQL server

[bungpeng]

May I know how do I save the file (image, excel file...) to SQL server? Where can I find those info?

Thank you.

 

[Derek Stone]

You can create a column of type "image", which can store binary data in sizes ranging from 0 bytes to 2 gigabytes.

This isnt standard practice however, since it can bloat the database quite quickly. Instead, store the files in a directory.

 

[bungpeng]

I know there is a data type call "image", but how do it convert my image file to binary format and insert into database? any example or references? TQ

 

[Robby]

I would follow Dereks advice and store the files in a directory, if you insist on storig them in the DB then this may help...

It get the image from the user (its for ASP.NET)
http://www.computerhelp.forum/showthread.php?s=&threadid=69196&highlight=image

 

[bungpeng]

TQ, this is what I want.

May I know why you comment This isnt standard practice? In what sense?

 

[Robby]

The answer lies in the rest of Dereks sentence, "...since it can bloat the database quite quickly"