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

2 Answers   HCL,

---

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

Can binary strings be converted into numeric or float data types?

0 Answers  

---

What is isnull() operator?

0 Answers  

---

---

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

---

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  

---

Where is localdb stored?

0 Answers  

---

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

---

How do I find the port number for sql server?

0 Answers  

---

What is shrink log file?

0 Answers  

---

What are the differences between char and varchar in ms sql server?

0 Answers  

---