Cross join combine every row from the left table with every row in the right table. This type of join is also called cartesian join.
It produce result set which is the number of rows in the first table multiplied by the number of rows in the second
In this post we will discuss about sql outer join. This type of joins is used in situations where we have to preserve all the data of one table.
Outer joins are similar to inner joins, but give a more flexibility when selecting data from related tables.
This joins preserve
Inner join is same as join, so we can use either inner join or join keyword.
Using this join we can joins two or more tables and we can also specify more then one predicate in the ON clause.
This type of join can be used in situations
Sometimes it is necessary to work with multiple tables using single query. Joins are used to achieve this. Tables are joined on columns that have the same data type and length in the tables.
Tables in a database can be related based on primary and foreign keys. A primary
SQL: DATA TYPE
When we defined columns in tables, parameters in procedures and functions, variables in T-SQL batches, we have to choose appropriate data type for those.
The data type contains the data that is supported. SQL server has an extensive set of data type that we can choose to match