It may be necessary to integrate the several elements of the date into one. In such cases, SQL Server’s DATEFROMPARTS function will come in handy.
Category: SQL Server Functions
DATALENGTH Functions in SQL Server
DATALENGTH is a function that returns the number of bytes used to represent any expression. This looks similar to LEN function that helps in identifying
SQL Server Identity Functions
Identity values are handled by a number of functions in Microsoft SQL Server. The functions assist in establishing the automatic sequential value for table rows,
Grouping and Subtotals the rows in SQL Server
During data analysis, data analysts must categorize data into categories so that different aspects of the information may be displayed in a more understandable manner.
Configuration Functions in SQL Server
The following are the list of configuration commands that helps to identify the configured settings information of current instance, in SQL Server. @@DATEFIRST This function
First_Value, Last_Value vs Lead, Lag in SQL Server
The First_Value function in SQL Server returns the first value in an ordered set of values and the Last_Value function returns the last value in an ordered set of
Big Data & SQL 