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
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Insert picture via stored procedure....

Author  Topic 

blocker
Yak Posting Veteran

89 Posts

Posted - 2010-05-31 : 21:00:06
Good day.!

I just want a little help on how to insert a picture to a table via a stored procedure and read it back via stored procedure also..

sample path is c:\sample.jpg.

Thanks for any help..

God bless.!


tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-01 : 12:53:47
You'll need to do this using a programming language such as C# or VB.NET. You can use the image data type for the storage of the image.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

blocker
Yak Posting Veteran

89 Posts

Posted - 2010-06-01 : 22:03:17
I am using vb..I just pass the picture path to a stored procedure variable. Thank you for the reply..
Go to Top of Page

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2010-06-02 : 09:10:30
You could use the openrowset method described here

http://www.databasejournal.com/features/mssql/article.php/3724556/Storing-Images-and-BLOB-files-in-SQL-Server-Part-2.htm



An infinite universe is the ultimate cartesian product.
Go to Top of Page

blocker
Yak Posting Veteran

89 Posts

Posted - 2010-06-03 : 00:08:10
thanks again.God bless
Go to Top of Page
   

- Advertisement -