• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

How to write a stored procedure to get Image

I want to pass a PK value to a store procedure, and the get an Image from SQL 2k which is Image field. Finally, I want to test this by using VB or asp application.

I searched the net, but only found inserting, but not retrieving.

Any ideas how to write the sp?
0
mscprojhot
Asked:
mscprojhot
  • 2
1 Solution
 
arbertCommented:
I would say don't store the images in a database.  Performance suffers, the database size grows very QUICKLY, and backup operations tend to be slower and harder to manage.

But, if you must, check this out (one of many examples):

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_10307313.hml
0
 
mscprojhotAuthor Commented:
Thanks for your info! But,

1. Since the old app is using this approach, I need to follow.
2. What I want is Stored Procedure Method.

Thanks!
0
 
arbertCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now