Answer / Girijesh Singh

In SQL Server, an inner join returns only matching rows from both tables or views being joined. A full outer join, on the other hand, returns all rows when there are matches in either table or view, with null values used to represent missing values.

If i am handling 150 servers then how to check the active jobs of all the servers?

0 Answers  

---

Define tempdb database?

1 Answers  

---

What is difference between line feed ( ) and carriage return ( )?

1 Answers  

---

What is usually the first word in a sql query?

1 Answers  

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1 Answers  

---

How to receive output values from stored procedures?

1 Answers  

---

What is checkpoint in sql server?

1 Answers  

---

Explain few examples of stored procedure over triggers?

1 Answers   ADITI,

---

What is Cross Join and in which scenario do we use Cross Join?

1 Answers   QuestPond,

---

How can you find out which stored procedures are recompiling?

1 Answers  

---

Does view occupy space?

0 Answers  

---

Explain how does the report manager work in ssrs?

1 Answers  

---