The below is to understand how we can handle JSON data in prior versions of SQL Server 2016. Sample JSON data is: {“accountNumber”: 2020112,
Category: SQL Server Functions
Logical vs Physical Computed Columns
Many people have asked me about the difference between using and not using ‘PERSISTED’ in a computed column; and how do we know whether the
Adding Multiple Columns With Default Value
Almost a decade before, I came across a requirement where I needed to add multiple columns in a table with default value. It took a
SQL Server – Replicate Function
SQL Server “Replicate” Function repeats a character expression to a specified number of times. It is equivalent to or alternative of Oracle’s RPAD function. Let’s’
Analytical & Window Functions
Please refer to my previous post, in which schema and data for EMP and DEPT tables available. The topic of this post is SQL Server
SQL Server – Date Time Functions
Here are a few examples of functions that can help you manipulate DATE in different manners. These will comprise most of your daily job routines.
Big Data & SQL 