Skip to content

Tag Archives: SQL-Server

Whenever any value is passed to the variable or column of character data type, the string value has single quotes(”) around them otherwise it will… Read More
While inserting data in tables, sometimes we need to capture insert timestamp in the table. There is a very simple way that we could use… Read More
CURRENT_USER() function :This function in SQL Server is used to return the current user’s name in the database of SQL Server in use. Features :… Read More
There are various databases that have huge collections of data, and we know that the data is arranged in an organized manner. The data present… Read More
AVG() : This function in SQL Server is used to return the average value of the specified expression. Features : This function is used to… Read More
GETUTCDATE() : This function in SQL Server is used to return the UTC date and time of the present database system in a ‘YYYY-MM-DD hh:mm:ss.mmm’… Read More
SYSTEM_USER() function :This function in SQL Server is used to return the current user’s login name. Features : This function is used to find the… Read More
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
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