Related Stored Procedures

MarceeMarc

Member
Joined
Dec 8, 2013
Messages
7
Programming Experience
Beginner
Can I write two (or three) stored procedures, with the second sp using a result from the first as a parameter? Thanks for any help and/or code!
MarceeMarc
 

jmcilhinney

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,501
Location
Sydney, Australia
Programming Experience
10+
A stored procedure contains SQL code. SQL code can call a stored procedure. Just as a method can call another method and assign its result to a variable in VB, so a stored procedure can call another stored procedure and assign its result to a variable in SQL.
 
Top Bottom