How can you fetch alternate records from a table?

0 Answers  

---

How can I create a new template for import ? : sql server management studio

0 Answers  

---

what is differece between union and union all

6 Answers  

---

What do you mean by sql server agent?

0 Answers  

---

What the class forname () does?

0 Answers  

---

---

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

What stored by the model?

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 is used to create a table by copying the structure of another table?

7 Answers  

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

When we should use and scope of @@identity?

0 Answers  

---