If you work with data in SQL Server, you probably use functions to manipulate, transform, or aggregate values. But did you know that there are two types of functions in T-SQL: scalar and table-valued?

Once deployed to the SQL Server, the CLR function appears in the Programmability, Functions, Scalar-valued Functions folder of the database, much like a T-SQL user-defined function. See Figure 1 for a ...

Function inlining in SQL Server 2019 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 ...

Removing duplicates from a SQL Server table without a unique index: It’s a bit more difficult to remove duplicate rows or tables without a unique index. In this scenario, using a common table ...

Function for splitting and splitting string data without the STRING_SPLIT ready function for SQL Server 2014 and below ... Create a table value function. As a parameter, the main string @s variable ...

Yet another new M function for you this week: the Table.Schema() function, which returns information about the columns in a table. There’s some fairly detailed documentation about what it returns here ...

If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results. This method won't work in SQL Server, but Microsoft's Trans ...

SQL Server has many different ways (column types) to represent date/time values, and depending on which one is used in the database table, you may have some surprising results when trying to consume ...