Anil Singh | Code-sample.com

What is a SQL Join?  W hen would you use  Joins? Join is used to fetch data rows from more than one tables simultaneously based on your join conditions. Types of joins in SQL:- 1.       INNER JOIN 2.       OUTER JOIN a.          Right Outer Join b.          Left Outer Join c.           Full Outer Join 3.       SELF JOIN 4.       CROSS JOIN 5.       MULTIPLE JOIN All the Joins are work between the table’s key relations. What is inner join in SQL?  when would you use it ? Inner Join returns the matched rows from both the tables. If both the keys are matched then return rows otherwise not! What is Left Outer Join in SQL?  when would you use it ? In the LEFT OUTER JOIN, returns all the matched row...

The ISNULL () function is used to replace NULL with the specified replacement value. This function contains only two arguments. The ISNULL () can only have one input. So, ISNULL () is faster than COALESCE (). The ISNULL () uses the first parameter type. The ISNULL () function is a T-SQL. Syntax:  SELECT ISNULL (NULL, 1) The COALESCE () can have multiple inputs and it will evaluate in order until one of them is not null. The COALESCE () function returns the first non-null value of its arguments. The COALESCE () not limited to arguments but must be of the same data type. The COALESCE () follows the CASE expression and returns the first non-null value. The COALESCE () is ANSI-Standard. Syntax:   SELECT COALESCE (NULL, NULL, 1, NULL) Summary: The NULL value for ISNULL () is converted to INT whereas for COAELSCE () you have to provide a type. a)       ISNULL(NULL, NULL) — Ruturns as int b)    ...