What is wide table?

0 Answers  

---

What is difference between count (*) and count column?

0 Answers  

---

What are the types of stored procedures in an sql server?

0 Answers  

---

How to write a query with an inner join in ms sql server?

0 Answers  

---

Is sql server free?

0 Answers  

---

---

How would you choose between a clustered and a non-clustered index?

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,

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

What is raid? : SQL Server Architecture

0 Answers  

---

Explain what is cte (common table expression)?

0 Answers  

---

do views contain data ?

0 Answers   MCN Solutions,

---

What is difference between oltp and olap?

0 Answers  

---