Solved

How to write a stored procedure to get Image

Posted on 2003-12-01
5
239 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
5 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 75 total points
ID: 9858372
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

749 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