year name
DATENAME() Function in SQL server.
February 28, 2020
DATENAME() Function in SQL server: The DATENAME() function returns a specified part of a date. It returns nvarchar…
DATENAME() Function in SQL server: The DATENAME() function returns a specified part of a date. It returns nvarchar…
DATEDIFF (): This function will return difference between two dates in any of the following datepart: Hours, day…
Function cannot be used to perform action that can modify data ex. Insert, Update & Delete.
When we want to return table as a result, then we can use table valued functions. User defined Table Valued function…
User defined scalar function returns single value as a result of function. We can return any data-type value from func…