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

As you can see, it takes the name of a fruit and a sales value and updates the appropriate row in the SQL Server table. I then created a new table in Excel with some new fruit sales values: Used this ...

JSON functions in SQL Server enable you to analyze and query JSON data, ... FROM sys.tables FOR JSON PATH. Check out the other posts in this four-part series in the links below (as they become ...