Returning multiple datasets from a stored proc in VB
- by Ryan Stephens
I have an encrypted SQL Server stored proc that I run with (or the vb .net equivalent code of):
declare @p4 nvarchar(100)
set @p4=NULL
declare @p5 bigint
set @p5=NULL
exec AA_PAY_BACS_EXPORT_RETRIEVE_S
@PS_UserId=N'ADMN',
@PS_Department=N'',
@PS_PayFrequency=2,
@PS_ErrorDescription=@p4 output
select @p4, @p5
this returns 2 datasets and the…
