What is blocking and how would you troubleshoot it?

2 Answers  

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

What is the Control Flow in SSIS

0 Answers   HCL,

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

What do you mean by tablesample?

0 Answers  

---

How does a profiler work?

0 Answers  

---

What are the functions in sql server?

0 Answers  

---

How many joins in sql server?

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,

---

What command do we use to rename a db, a table and a column?

0 Answers  

---

What is multi-statement table-value user-defined function?

0 Answers  

---