Skip to content

Tag Archives: SQL-Server

DATEDIFF() function : This function in SQL Server is used to find the difference between the two specified dates. Features : This function is used… Read More
TRIM() function : This function in SQL Server is used to omit the space character or additional stated characters from the beginning or the ending… Read More
As a SQL DBA, we might need to write a SQL Query to Find all Tables that Contain Specific Column Name with example. Below screenshot… Read More
GETDATE() function : This function in SQL Server is used to return the present date and time of the database system in a ‘YYYY-MM-DD hh:mm:ss.mmm’… Read More
ISDATE() function : This function in SQL Server is used to check if the specified expression is a valid date or not. Features : This… Read More
CURRENT_TIMESTAMP() function : This function in SQL Server is used to return the current date as well as time. And the format of the output… Read More
DAY() function : This function in SQL Server is used to return the day of the month i.e, from 1st to 31st for date stated.… Read More
MONTH() function : This function in SQL Server is used to return the month of the year i.e, from 1 to 12 for a date… Read More
YEAR() function : This function in SQL Server is used to return the year for a date stated. Features : This function is used to… Read More
TRANSLATE() function : This function in SQL Server is used to return the translated string of the string stated in the first argument of this… Read More
SOUNDEX() function : This function in SQL Server is used to return a four character code in order to evaluate the similarity of two specified… Read More
CONCAT() : This function in SQL Server helps to concatenate two or more strings together. CONCAT() function can accept a minimum of 2 parameters and… Read More
NCHAR() function : This function in SQL Server is used to return the Unicode character that is based on the number code. For example, if… Read More
QUOTENAME() function : This function in SQL Server is used to return a Unicode string with delimiters added in order to make the string a… Read More
REPLICATE() function : This function in SQL Server is used to repeat the specified string for a given number of times. Features : This function… Read More