Tag: functions

DIFFERENCE BETWEEN TWO DATES BY DATEDIFF_BIG: DATEDIFF_BIG is a new function introduced in SQL Server 2016. We will also see what is the difference between the DATEDIFF and the new DATEDIFF_BIG function. The syntax for DATEDIFF and DATEDIFF_BIG are both similar however DATEDIFF will return a int value and the DATEDIFF_BIG will return a big

Starting from SQL server 2016 we have new String split function which will help to split a string in rows. With earlier version of sql server a developer would have to create his own custom scripts to achieve this task. Syntax : STRING_SPLIT( ‘string’,’separator’). Split string will divide the input string using a separator into