DATALENGTH is a function that returns the number of bytes used to represent any expression. This looks similar to LEN function that helps in identifying
Tag: LENGTH function usage SQL Server
Handling “Json” and “Unstructured” Data in SQL
The below is to understand how we can handle JSON data in prior versions of SQL Server 2016. Sample JSON data is: {“accountNumber”: 2020112,
Big Data and SQL 