Explain the use of containers in ssis and also their types?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

What are the advantages of user-defined functions over stored procedures in sql server?

0 Answers  

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

What is the difference between nvl and nvl2?

0 Answers  

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

How do you debug a procedure in sql server?

0 Answers  

---

What is a sql join?

0 Answers  

---

What is 1nf 2nf and 3nf?

0 Answers  

---

Explain the concept of recursive stored procedure.

0 Answers  

---

What is the correct order of the logical query processing phases?

0 Answers  

---