USER_NAME() : This function in SQL Server is used to return the username of the database that is based on the id stated. Features :… Read More
Tag Archives: DBMS-SQL
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
CEILING() function :This function in MySQL is used to return the smallest integer value that is greater than or equal to a specified number. For… Read More
AVG() function : This function in MySQL is used to return the average value of the specified expression. Features : This function is used to… Read More
BIT_COUNT() function in MySQL is used to return the number of bits that are active in the given input. Active bits can be counted as… 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
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
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
Courses
