Answer / seshagiri

DTS is set of graphical tools and programmable objects,
using that we can extract,transform, and consolidate data
from source in to multiple destinations.

Tasks are....

Transform Data

Copy and Manage Data

Function as Jobs

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

Why and when do stored procedure recompile?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

Can we call stored procedure in trigger?

0 Answers  

---

Do you know what is replace and stuff function in sql server?

0 Answers  

---

What are the properties of primary key?

0 Answers  

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  

---

How much does sql server 2016 cost?

0 Answers  

---

How do you simulate a deadlock for testing purposes

1 Answers  

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

What structure can you implement for the database to speed up table reads?

0 Answers  

---