Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined. This means they will be folded into the query and no longer incur the UDF overhead.

Snowflake is adding generative AI-powered SQL functions to help data analysts and their organizations analyze unstructured data with SQL. These new AISQL functions will be part of Snowflake’s ...

Probably for a query that your application runs occasionally, in-memory processing of JSON data might still be an option. In general, though, querying through JSON-dedicated functions and letting SQL ...

With such a huge percentage of all our IT systems relying on data to function, SQL will not be going away any time soon. So, let’s celebrate SQL turning 50, and consider how we can continue to ...

Code Focused 10 More New T-SQL Functions Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest. By Sam Nasr 01/03/2013 The first part of this ...