Some queries related to SQL

0 Answers   Motorola,

---

what is a join and explain different types of joins? : Sql server database administration

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

How to find tables without indexes?

0 Answers  

---

Explain the rules for designing files and file groups in sql server?

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

Define self join in sql server joins?

0 Answers  

---

Does a sql server 2005 select statement require a from?

0 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

When we should use and scope of @@identity?

0 Answers  

---

What are the different types of Indexes available in SQL Server?

0 Answers  

---