Splitting Strings With OPENJSON

2019-05-06 1 Comments

Another option for splitting strings in TSQL. This one addresses a shortcoming of STRING_SPLIT. [...Read More]

Parsing JSON Data In SQL Server

2019-05-05

Get started with a few examples using the OPENJSON and JSON_VALUE functions. [...Read More]

2018-03-29

Concatenate With Separator-a new T-SQL function that "addresses" a real world problem. [...Read More]

2018-03-23

SQL Server 2017 gives us the new T-SQL function TRIM(), which has an added surprise. [...Read More]

2018-03-04

After stubbing my toe on return data types, I find the new SQL Server 2017 function STRING_AGG() is pretty cool. [...Read More]

2018-01-17

SQL Server Reporting Services 2017 now has a separate installation. There have been changes... [...Read More]

2017-11-16

Dave ponders Machine Learning Services and sp_execute_external_script WITH RESULT SETS...again. [...Read More]

2017-11-15

Dave ponders Machine Learning Services and sp_execute_external_script WITH RESULT SETS. [...Read More]

2017-11-06

A stored procedure can return multiple result sets. Why can't I do the same with sp_execute_external_script? ?? [...Read More]

2017-10-05

How to configure Visual Studio to run Python, using the SQL Server 2017 Python interpreter. [...Read More]