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
Tag Archives: SQL-Server
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