What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---

What is the use of DBCC commands?

4 Answers   NA,

---

What is sql server database?

0 Answers  

---

Write a code to select distinct records without using the DISTINCT keyword.

0 Answers   Aspiring Minds,

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---

what is lazy writer?

1 Answers   Wipro,

---

How to write stored procedure to update the data in 10 tables

4 Answers  

---

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

---