CASE

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2023-07-07

549 reads

Demystifying the use of CASE in an ORDER BY statement

Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(140)

You rated this post out of 5. Change rating

2015-06-05 (first published: 2012-04-26)

26,669 reads

If you are considering any of the ISACA AI certs like the Advanced Artificial...

Are you currently using Microsoft Fabric or considering migrating to it? If so, there...

Track SQL Server Configuration Changes Using the Error Log If you...

Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...

Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...

Comments posted to this topic are about the item Detecting Deadlocks Quickly

In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?