IN operator we use when we Determines whether a specified value matches any value in a sub query or a list. The IN operator allows you to specify multiple values in a WHERE clause.it also helps reduce the need to use multiple OR conditions. Continue reading “Using IN in SQL Server”

 
DATEPART() function returns a value equal to the part of a specified date.

Summery

DATEPART(datepart, date)

where date is the valid date or a string in date format
and datepart can be one of the following:

Example

Suppose you have a table ‘tbl_employee’
tbl_employee

The following query return the date of joining of the Ankur:

SELECT datepart("year", DateOfJoin)

Output will be:

—————–
1995

Now if you want to current year, you can use the following query:

SELECT DATEPART("Year",GETDATE())

–or—

SELECT DATEPART("yy",GETDATE())

GETDATE() function return the current date.

 
DATEDIFF() function is very useful when we are working with date operations. DATEDIFF function return the difference between date items in days, weeks, minutes, years and hours. It can also used with WHERE clause. Continue reading “DATEDIFF() function in SQL Server”

STR() function

In Sql Server STR() function converts a numeric value to character data. STR() function allows us to specify the total length and number of decimal places to be included when it is converted to character data. Continue reading “STR(), CHAR(), and ASCII() function in SQL Server”

ISNULL function replaces NULL values with the specified replacement value. you can use ISNULL as Continue reading “ISNULL in SQL Server”