How can you append an identity column to a temporary table?

0 Answers  

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

---

What is the boxing and unboxing concept in .net?

0 Answers  

---

What is precedence constraint?

0 Answers  

---

---

mention different types of relationships in the dbms?

0 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---

What are the different types of collation sensitivity in sql server?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

Name few of the dcl commands in sql?

0 Answers  

---

What is the default value of CHAR type?

10 Answers   Bosch,

---