Explain the use of containers in ssis?

979

---

Why is the need for data conversion transformations?

1086

---

What is conditional split?

1096

---

Can we add our custom code in ssis?

1004

---

Explain the difference between control flow and data flow?

1016

---

What are the purposes and advantages stored procedure?

976

---

Determine when to use stored procedure to complete sql server tasks?

1074

---

What is extended stored procedures?

975

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1067

---

What security features are available for stored procedure?

1049

---

What is stored procedures?

1062

---

In what three ways is the return statement used in a stored procedure?

1029

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

938

---

Explain syntax for viewing, dropping and disabling triggers?

970

---

Explain triggers?

1026

---