Query store is a new powerful feature introduced in SQL 2016 which stores the query plan, statistics and query execution…
DIFFERENCE BETWEEN TWO DATES BY DATEDIFF_BIG: DATEDIFF_BIG is a new function introduced in SQL Server 2016. We will also see…
Starting from SQL server 2016 we have new String split function which will help to split a string in rows.…
With the new translate function in SQL server 2017 you can now replace the string for multiple characters at the…
Before Sql server 2017 we only had LTRIM and RTRIM function available to remove spaces from left and right separately. …
SQL Server concat_ws function available starting 2017: Concat_ws is a new function introduced in sql server 2017. Syntax: CONCAT_WS (…