CASE/WHEN return type

Morten Nilsen

Rate me:

0.00/5 (No votes)

24 Nov 2010CPOL

5.7K

Unless you are placing this code in a stored procedure, you could just as well do this:SELECT *FROM ( SELECT 'A1' AS String1,'B1' AS String2, GETDATE() AS DateCol UNION ALL SELECT 'A2','B2', GETDATE()) AS dORDER BY And then append the sanitized column name to sort...

Unless you are placing this code in a stored procedure, you could just as well do this:

SQL

SELECT *
FROM (
   SELECT 'A1' AS String1,'B1' AS String2, GETDATE() AS DateCol
   UNION ALL
   SELECT 'A2','B2', GETDATE()
)  AS d
ORDER BY

And then append the sanitized column name to sort by before executing it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Morten Nilsen

Norway

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

CASE/WHEN return type

License

Comments and Discussions