SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable | Journey to SQL Authority with Pinal Dave

This article is as per request from Application Development Team Leader of my company. His team encountered code where application was preparing string for ORDER BY clause of SELECT statement. Application was passing this string as variable to Stored Procedure (SP) and SP was using EXEC to execute the SQL string. This is not good… Continue Reading...

Source: SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable | Journey to SQL Authority with Pinal Dave