In SQL, Function can be defined as a block/set of code that is used to perform a specific task or accomplish a particular purpose.
In SQL, CHARINDEX function is used to search the position number of a character or substring in a string. In case the substring is not found then it retur…
In SQL, DATEADD function is used to add or subtract specific 'date/time interval' to a date or time.
In SQL, CONCAT function is used to combine two or more strings together into a single string.
In SQL, LEN function is used to determine the length of the specified string.
In SQL, REPLACE function is used to replace all occurrences of a specific substring with another substring.
In SQL, Substring function is used to extract a portion(substring) of a specified string value based on specified starting and ending length.
In SQL, CASE statement is used to perform different actions or return different values based on the specified conditions. It is very similar to the 'if-el…
In SQL, GETDATE function is used to return the current system date and time in default format of the SQL Server instance.
In SQL, DATEPART function is used to extract the specific part from a given date and time such as year, month, day and hour etc.