How efficient you are in oracle and SQL server?

0 Answers   CGI,

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What is nolock?

0 Answers  

---

What are the advantages of having an index on the sql server?

0 Answers  

---

What is difference between group by and having?

0 Answers  

---

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

---

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---

What is the definition for sql server 2000?

0 Answers  

---

Explain the first normal form(1nf)?

0 Answers  

---

What do you understand by SQL*Net?

0 Answers   Tech Mahindra,

---

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---