output parameter from MS SQL stored procedure

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
output parameter from MS SQL stored procedure

VB How-To Ask your "How do I do this with VB?" questions in this forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

March 14th, 2005, 05:00 PM

nav1

Registered User

Join Date: Mar 2005

Posts: 6

Thanks: 0

Thanked 0 Times in 0 Posts

output parameter from MS SQL stored procedure

Dear Friends

I have a stored procedure in MS-SQL database which returns an output parameter
In query analyser I execute the procedure as fallows

DECLARE @@param_out INT
exec proc_1 'param_in_1','param_in_2',@@param_out OUTPUT
PRINT @@param_out

How can i get the value of param_out from VB code?

Thanks
Nav

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get Stored Procedure Output using Access VBA	LandLocked	Access VBA	3	June 20th, 2007 11:20 AM
XML Output from stored procedure	NigelBronson	ASP.NET 2.0 Basics	0	October 15th, 2006 06:24 PM
Passing Variable MS Proj to SQL Stored Procedure	Abaxt	Access VBA	2	July 7th, 2005 11:05 AM
Calling stored procedure with output parameters	bansalh	SQL Server 2000	2	November 10th, 2004 11:00 AM
MS SQL Stored procedure and VBA	jesseleon	Pro VB Databases	0	July 30th, 2004 01:16 PM