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

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