<div>
I would say don't store the images in a database. &nbsp;Performance suffers, the database size grows very QUICKLY, and backup operations tend to be slower and harder to manage.<br />
<br />
But, if you must, check this out (one of many examples):<br />
<br />
<a href="https://www.experts-exchange.com/questions/10307313/MSSQL-VB.html" rel="ugc">https://www.experts-exchange.com/questions/10307313/MSSQL-VB.html</a>
</div>


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):

https://www.experts-exchange.com/questions/10307313/MSSQL-VB.html [https://www.experts-exchange.com/questions/10307313/MSSQL-VB.html]

<div>
Thanks for your info! But,<br />
<br />
1. Since the old app is using this approach, I need to follow.<br />
2. What I want is Stored Procedure Method.<br />
<br />
Thanks!
</div>


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!

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
I searched the net, but only found inserting, but not retrieving.<br />
<br />
Any ideas how to write the sp?
</div>
</div>


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?

How to write a stored procedure to get Image

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.