DROP IF EXISTS
SQL Server 2016 has released an optional IF EXISTS clause with DROP statement that can be used as DROP IF EXISTS. DROP IF EXITS verify… Read More »DROP IF EXISTS
Home »
sql server 2016
SQL JSON_VALUE Function
JSON_VALUE is a JSON function which is used to extracts scalar value from JSON string. It returns a single text value of type nvarchar. It… Read More »SQL JSON_VALUE Function
Row Level Security in SQL Server
Row-Level Security enables you to use group membership or execution context to control access to rows in a database table. Row level security feature introduced… Read More »Row Level Security in SQL Server
SQL Server Download links
Following are the links to download SQL Server 2019 and Database sample files
SQL STRING_SPLIT function
SQL Server STRING_SPLIT function is used to split a string into a table that consists of rows of substrings based on a specified separator. This function was introduced in SQL Server 2016 .
STRING_SPLIT requires the compatibility level to be at least 130. When the level is less than 130, SQL Server is unable to find the STRING_SPLIT function.
SQL TRANSLATE()
The SQL TRANSLATE() is a string function that is used to replaces a sequence of characters in a string with another sequence of characters.
The function replaces a single character at a time. Until SQL Server 2016, we used use REPLACE() function to replace each character.