How to store image in sql server 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to store image in sql server 2005

Author

Topic

vinitnri
Starting Member

3 Posts

Posted - 2010-09-21 : 03:05:02

Hi.. Expert
Good Afternoon

I have a problem in sql 2005

I want to store image as a data in a sql database. what will be command to store image in sql server.

Like..
we have a table User and the fields are.. Username,Password,Email,UserImage.
I want to insert image of the User like abc.jpg..
what will be command to create table for imagae through sql command not any other language..like asp.net,vb.net

vinit k.k.

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-09-21 : 04:12:33

Have a look at:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6014
http://technet.microsoft.com/hi-in/library/cc917636(en-us).aspx

alexylee
Starting Member

14 Posts

Posted - 2011-10-04 : 13:24:51

If one wants to store image to SQL table without any programming,
one can use this handy tool.

http://www.sqlmgmt.com/sql/image-to-sql

X002548
Not Just a Number

15586 Posts

Posted - 2011-10-04 : 15:38:15

Just store the location of the image. Don't store images in sql server

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Kristen
Test

22859 Posts

Posted - 2011-10-04 : 18:26:11

Its an old post Brett, alexylee is just spamming it ...

vmvadivel
Yak Posting Veteran

69 Posts

Posted - 2011-10-04 : 22:17:27

If you want to upload an image into SQL Server then try out OPENROWSET. Check out my blog post with sample script here - http://vadivel.blogspot.com/2005/10/saving-images-as-blob-into-sql-server.html

Best Regards
Vadivel

http://vadivel.blogspot.com

jassi.singh
Posting Yak Master

122 Posts

Posted - 2011-10-05 : 02:47:42

Hi,
Refer http://www.codeproject.com/KB/database/Store_images_in_SQL_Serve.aspx
http://www.eggheadcafe.com/articles/20030624.asp

Please mark answer as accepted if it helped you.

Thanks,
Jassi Singh

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-10-05 : 02:54:04

quote:
Originally posted by jassi.singh

Please mark answer as accepted if it helped you.

Jassi, there isn't a way to do that in this forum.

KH
[spoiler]Time is always against us[/spoiler]

Kristen
Test

22859 Posts

Posted - 2011-10-05 : 03:23:55

I have already asked Jassi not to do that, twice, in other threads.

Just posting and not reading or becoming part of the community here.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources