What are the different types of joins and what does each do?

2 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---

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

0 Answers  

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

---

Explain rdbms?

0 Answers  

---

What is a Join in SQL Server?

3 Answers  

---

Can we check locks in database? If so, how can we do this lock check?

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,

---

what is trigger . hw will it use them

2 Answers   TCS,

---

how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

---