Skip to content

Tag Archives: SQL-Server

SYSDATETIME() : This function in SQL Server is used to return the computer’s date and time in which the SQL Server is operating at present.… Read More
ISNULL() : This function in SQL Server is used to return the value given, in case the stated expression is NULL. Moreover, in case the… Read More
DATEPART() function :This function in SQL Server is used to find a given part of the specified date. Moreover, it returns the output value as… Read More
DATENAME() function : This function in SQL Server is used to find a given part of the specified date. Moreover, it returns the output value… Read More
SESSIONPROPERTY() function : This function in SQL Server is used to return the settings of the session that is specified in the argument section. Features… Read More
COUNT() function : This function in SQL Server is used to find the number of indexes as returned from the query selected. Features : This… Read More
MIN() : This function in SQL Server is used to find the value that is minimum in the group of values stated. Features : This… Read More
MAX() : This function in SQL Server is used to find the value that is maximum in the group of values stated. Features : This… Read More
SUM() : This function in SQL Server is used to compute the sum of the specified group of values. Features : This function is used… Read More
SESSION_USER() : This function in SQL Server is used to return the current user’s name in the database of SQL Server that is in use.… Read More
Stored Procedure: The stored procedure has the following key points as follows. It is a collection of SQL statements such as if you want to… Read More
NULLIF() : This function in SQL Server is used to check if the two specified expressions are equal or not. Features : This function is… Read More
ISNUMERIC() function : This function in SQL Server is used to check if the stated expression is numeric or not. Features : This function is… Read More
DATEADD() function : This function in SQL Server is used to sum up a time or a date interval to a specified date, then returns… Read More
DATEFROMPARTS() function : This function in SQL Server is used to return a date from the given values of year, month and day. Features :… Read More