Answer / guest

There are three types of joins: Inner Join, Outer Join,
Cross Join

Answer / hokar

In some situations we may need to pull data from one or
more related tables at a time. In such cases we use JOINs
to extract data from more than one table at a time and
display the information in a single result set.
There are several types of joins.(1)Inner Join
(2)Outer
Join------Right Outer Join,Left Outer Join, Full Outer Join
Inner join is used to link tables on a common column and
return records that match in those columns.
Right Outer Join displays all records from the table on
right most side of the JOIN clause whether or not there are
matching records in the Left table.
Left Outer Join displays all records from the table on the
left most side of the JOIN clause whether or not there are
matching records on the Right table.
Full Outer Join diplays all records from both right and
left tables.
Example: If we have a HR database with employee information
table, salary information table, sick days table etc, and
if we want to know which employee
have used more than 15 sick days, we would need the
information form sick days table and employee information
table in a single result set.

What is query optimizer in sql server?

0 Answers  

---

Can coalesce return null?

0 Answers  

---

What is inline table-value user-defined function?

0 Answers  

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

---

How to end a stored procedure properly in ms sql server?

0 Answers  

---

What is a sql join?

0 Answers  

---

What is the difference between stored procedure and user defined functions?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

How to optimize stored procedure optimization?

0 Answers  

---

What is 2nf normalization?

0 Answers  

---

What samples and sample databases are provided by microsoft?

0 Answers  

---

Does union all remove duplicates?

0 Answers  

---