Define inner join? Explain with an example?

0 Answers  

---

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

---

What is local temp table?

0 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

Explain what are commit and rollback in sql?

0 Answers  

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

How can you find out how many rows returned in a cursor?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

what is advantages in sql 2005 over sql 2000?

4 Answers  

---

What is the distinction amongst delete and truncate?

0 Answers  

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

---

What is a derived table?

0 Answers  

---