- Blogs
- Tagged with Stored Procedures
All Blogs Tagged With Stored Procedures
-
Dynamic/Conditional Order By Clause in SQL Server/T-SQL
25 January 2009 - 5:42 PM / by Dominic Pettifer. 4 Comments for Dynamic/Conditional Order By Clause in SQL Server/T-SQL.
Technical Article - This article shows you how to achieve a conditional Order By clause in your SQL Server Stored Procedures, without having to resort to inline SQL in your applications, or Dynamic SQL (yuck!) in your Stored Procedures.
Tags for Dynamic/Conditional Order By Clause in SQL Server/T-SQL.
-
Output Parameters AND Recordsets From a Stored Procedure
24 November 2006 - 10:32 PM / by Dominic Pettifer. 9 Images for Output Parameters AND Recordsets From a Stored Procedure. 9 Comments for Output Parameters AND Recordsets From a Stored Procedure.
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.
Tags for Output Parameters AND Recordsets From a Stored Procedure.
Quick Poll
What is your DIP/IOC Container of choice?
- 24.0% - Castle Windsor
- 15.6% - StructureMap
- 15.6% - Unity
- 10.4% - Ninject
- 9.7% - Spring.NET
- 5.8% - Huh!?
- 5.2% - None - DIP is the work of Satan!
- 4.5% - Autofac
- 4.5% - None - But I want to look into DIP
- 2.6% - DIY (my own container)
- 0.6% - PicoContainer.NET
- 0.6% - LinFu
- 0.6% - Other
- 0% - Puzzle.NFactory
- 0% - S2Container.NET
Thank you for voting!
View Comments (5) (See previous polls)Latest Tweets
-
BTW: that last tweet was a joke, no actual money will be forthcoming
about 1 hour ago from Echofon -
I'll give £10 to anyone who retweets this message before 6pm
about 1 hour ago from Echofon -
RT: @ronskidoodles: OKAY OKAY OKAY!! The RT competition/freebie/stupid idea is now over!! @sironfoot is the last person to get one. - YAY!!!
about 1 hour ago from Echofon -
@ronskidoodles promises illustrations for anyone who retweets his new website. Gets over 210 RT (so far). Welcome to Twitter :-)
about 1 hour ago from Echofon