Answer Posted / prasanna

1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1938

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1029

---

What are the different types of triggers in SQL SERVER?

1141

---

Why use “nolock” in sql server?

1064

---

What is use of dbcc commands?

1075

---

What are different types of raid configurations? : SQL Server Architecture

1086

---

What is the advantage of sql server?

1039

---

How to see existing views in ms sql server?

1049

---

What do you mean by sql server 2005 express management tools?

1316

---

What is the cartesian product of the table?

958

---

Do you know concepts and capabilities of sql server?

1067

---

What are the different types of indexes?

1120

---

How do you delete a data source?

1013

---

What are the elements of dbms?

969

---

how to define testing of network layers? : Sql server database administration

976

---