Output Parameters AND Recordsets From a Stored Procedure (Images)

24 November 2006 - 10:32 PM / by Dominic Pettifer. 1 Image 9 Comments

Technical Article - Just had a frustrating past few hours with Stored Procedures in SQL Server 2005 and ASP.NET. I was trying to return both output parameters and a recordset from the same stored procedure and the caller (a .NET data access class) wasn’t having any of it! I found a solution so thought I better post it here to help others, and in case I forget.

Images

  • Result of Stored Procedure using output params and a recordset

    Result of Stored Procedure using output params and a recordset

Random Image

Hamster standing next to a tiny hard drive.

Tiny hard drive or GIANT hamster? You decide! (from the blog And So It Begins )

Quick Poll

What is your DIP/IOC Container of choice?

Poll Vote
(see results)
View Comments (625) (See previous polls)

Latest Tweets

  • And YouTube still auto-fucking-plays videos!! This is TWO-THOUSAND-AND-FUCKING-TWELVE FFS!!!

    about 20 hours ago from web

  • On a side-note, YouTube's commenting system is god-awful atrocious dreadful horrible horrible horrible!! Constant meaningless error messages

    about 20 hours ago from web

  • JavaScript is slow mmmkay http://t.co/NbB4eQjw - Actually, no, it's not http://t.co/kpGEIoPO #nodejs

    about 20 hours ago from web

  • TFS: It's super expensive, so it must be brilliant, right? Like Sharepoint #tekpubtfstitlesuggestion

    5:22 PM February 3rd from web

View Dominic Pettifer's Twitter page.