what is DTS what are tasks available

1 Answers   Wipro,

---

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,

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---

What is meant by datasource?

0 Answers  

---

What is resultset concur_updatable?

0 Answers  

---

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

What is enhanced database mirroring in sql server 2008?

0 Answers  

---

Explain how many types of relationship?

0 Answers  

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  

---

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

How to restore performance issues and how to check?

0 Answers  

---

What is the template in sql?

0 Answers  

---