How can a user-defined datatype be created?

0 Answers  

---

Is trigger fired implicitely?

2 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,

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

---

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

---

What do you mean by recursive stored procedure?

0 Answers  

---

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

---

Explain what is it unwise to create wide clustered index keys?

0 Answers  

---

How to bind a view to the schema of the underlying tables?

0 Answers  

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

What is 1nf 2nf?

0 Answers  

---

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---