Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to write a stored procedure to get Image

Posted on 2003-12-01
5
Medium Priority
?
255 Views
Last Modified: 2009-07-29
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
Comment
Question by:mscprojhot
  • 2
3 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 9856323
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
 

Author Comment

by:mscprojhot
ID: 9856368
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
 
LVL 34

Accepted Solution

by:
arbert earned 300 total points
ID: 9858372
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question