Tag: sql expressions

How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective

14:49 Database development, Perfomance Tuning, Tables, Work with data

We often see poorly written complex SQL queries running against a table or tables in databases....
Read More

Using CASE Expressions in SQL Server

18:25 Database development, Statements

Introduction CASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion...
Read More