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.
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: datepart Abbreviation year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week … Continue reading DATEPART() function in SQL Server
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.
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.
DATALENGTH DATALENGTH function returns the number of bytes used to represent any expression. DATALENGTH is especially very useful with varchar, varbinary, text, image, nvarchar, and ntext data types because these data types can store variable-length data.
ISNULL function replaces NULL values with the specified replacement value. you can use ISNULL as
The GETDATA() function return the current date and time. This value is derived from the operating system of the computer on which the instance of SQL Server is running.
You can pass a name string into USER_ID() function and get the current database ID for that name. This is very useful when we are accessing the system tables and need to check names against group membership or permission value.
SPACE() The SPACE() function returns the specified number of the spaces. This function is mainly useful for formatting.
The SUBSTRING() function returns part of a character, text, binary, or image expression.