• Blogs
• Tagged with SQL Server

All Blogs Tagged With SQL Server

• Dynamic/Conditional Order By Clause in SQL Server/T-SQL

  25 January 2009 - 5:42 PM / by Dominic Pettifer. 3 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.

  • Code Quality
  • SQL Server
  • Stored Procedures

• Output Parameters AND Recordsets From a Stored Procedure

  24 November 2006 - 10:32 PM / by Dominic Pettifer. 8 Images for Output Parameters AND Recordsets From a Stored Procedure. 8 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.

  • SQL Server
  • Stored Procedures