Answer / sravanthi

The Join keyword is used to query data from 2 or more
tables based on the relationship between the columns in the
table.

1. Join : Returns records when there is atleast one matched
record in both the tables.
2. Left Join : Returns all the records of the left table
irrespective match records in both the tables.
3. Right join : It is just reverse case of left join.
4. Full Join : Returns all the records from both the tables
irrespective matching.

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

What is the purpose of floor function?

0 Answers  

---

How to create a new schema in a database?

0 Answers  

---

What triggers long term care?

0 Answers  

---

Explain user defined views?

0 Answers  

---

Can you explain important index characteristics?

0 Answers  

---

What is a select query statement in ms sql server?

0 Answers  

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

---

How to download microsoft sql server 2005 express edition?

0 Answers  

---

Relational calculus is what type of language?

0 Answers   HCL,

---

What is a collation?

0 Answers  

---