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 ...

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 ...

In SQL Server, a function that returns a single value is known as a “scalar UDF” or “scalar user defined function”. ... A table-value function normally returns a set of rows, ...

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 ...