Dynamic sorting and paging in SQL Server with the CASE expression(gregbeech.com)
submitted by
gregbeech(76) 3 years, 10 months ago
Demonstrates how to write T-SQL queries that implement dynamic sorting and paging without using dynamic SQL, and which have the same performance characteristics as statically sorted queries. I bet you didn't know you could use the CASE expression like this... read more...
|category: Database
|Views: 42
tags:
Database another
Everyones tags:
Your Tags: