Answer Posted / rupinder kaur

there are five types:
inner join
outer join: left outer join,right outer join, full outer
join
equi join
cross join self join

What is model database in sql server?

562

---

Explain about protocol layer present in SQL server?

604

---

Does a sql server 2005 select statement require a from?

568

---

Where the sql logs gets stored?

533

---

Explain differences between web edition and business edition?

103

---

---

What does dml stand for?

496

---

What is the sql case statement used for? Explain with an example?

528

---

What is sqlservr.exe - process - sql server (sqlex?press)?

590

---

How do we Backup SQL Azure Data?

86

---

What is report server project?

106

---

What is failover clustering overview?

581

---

Why are views required in the sql server or in any other database?

527

---

What is a data collection table?

534

---

How many types of local tables are there in sql server?

500

---

How to delete database objects with "drop" statements in ms sql server?

585

---