How do you create a clustered index?

0 Answers  

---

What is the use of DBCC commands?

4 Answers   NA,

---

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  

---

what is difference between NULL and ISNULL in SQL Server 2008?

0 Answers   MCN Solutions,

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

---

How to create a simple user defined function in ms sql server?

0 Answers  

---

what is nonclustered index

0 Answers  

---

Explain primary key, foreign key and unique key?

0 Answers  

---

in how many ways we can use count()

2 Answers  

---

What is indexed views? plz explain with example?

2 Answers  

---