Answer / ramesh

The Concept of joining a table with it self in called "self
join"

Answer / shekar

the concept of joining a table with it self in called "self
join"

Answer / rrrrrrrrrr

The Concept of joining a table with it self in called "self
join"

Answer / gagan

Self join correlated rows of a table with other rows in the
same table.

Eg:
select a.name+'issue the book= '+b.book form lib a,lib b
where rollno between 1 and 10

what is physical sort data and logical sort data in index?

2 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

What is similarity and difference between truncate and delete in sql?

0 Answers  

---

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---

What you can do to delete a table without the delete trigger firing?

0 Answers  

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

What is partitioned view?

0 Answers  

---

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---