Default value for a image

Hi, i would like to insert a default value for a image column in sql server express. is this possible?

I would like to do this so that when users pull up a record in my web forms there is something to see.
thanksyou can either do this from the backend or front end. in table design view you can set the default vale..from your front end you can check for null and show a default image instead.|||Don't store your images in the database. One main reason is the size of the db will grow quickly. It's almost always better to put them on the server's hard drive. In your database you can store the name of the image and call it that way. Setup a varch column of whatever length you need. To answer your default question...store a default image on the server, "myImage.gif" for example. Then insert this image name into your varchar column when you need the default value.|||::Don't store your images in the database. One main reason is the size of the db will grow
::quickly.

So what?

There are arguments in vfacvour and against storing images in the database, but this one is ridiculous.

You may not realize it, bit 1gb = 1gb. Whether I blow 1gb on a SQL Server database, or in the file syste, does not make a dime of a difference.

And then you ignore a lot of the problems you get yby your approach.

* How do you handle transactional guarantee that all images are deleted when they should be?
* How do you make a coherent backup of all material? Note the word "coherent" here.

What exactly is your problem with having a 2gb SQL database? You use shared hosting on a plan that does make a difference? Get a good host.