L'actualité technique MS SQL Server en France (et ailleurs)

Sql Functions

Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions
Introduction SQL Server 2022 introduced the LEFT_SHIFT and RIGHT_SHIFT functions, which allow you to manipulate numbers by shifting […]

19 mars 2025 dans Sites anglophones étiqueté binary operations / bitwise operations / bitwise operations in SQL Server / bitwise shift / bitwise shift examples / data manipulation / date expressions in SQL / LEFT_SHIFT / RIGHT_SHIFT / Sql Functions / SQL optimization / SQL Server / SQL Server 2022 / t-sql par sqlservercentral.com

Understanding the Logical Functions IIF and Choose in SQL Server ...
Introduction In SQL Server 2022, developers often need to implement conditional logic within their queries. Whether it’s selecting […]

5 mars 2025 dans Sites anglophones étiqueté CHOOSE function / conditional logic / DATEPART function / IIF function / Sql Functions / SQL Query Optimization / SQL Server 2022 / SQL Server Examples / SQL Server Queries / SQL Server tips / t-sql par sqlservercentral.com

SQL Window Functions Series: RANK() and DENSE_RANK()

Welcome to the fascinating world of SQL Window functions! As we journey through the intricate labyrinths of databases […]

15 novembre 2023 dans Sites anglophones étiqueté Advanced Querying / Advanced SQL / DENSE_RANK() / Performance / query optimization / RANK() / Ranking Functions / SQL / sql commands / SQL Data Exploring / Sql Functions / SQL Query / SQL Script / Window Functions par sqlservercentral.com