What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

What is scalar user-defined function?

0 Answers  

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

What is relationship? What number of sorts of relationship are there?

0 Answers  

---

How would we use distinct statement? What is its use?

0 Answers  

---

---

What is inner join? Explain with an example?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

What is extended stored procedures?

0 Answers  

---

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

2 Answers   IBM,

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

How to create indexed view?

0 Answers  

---