Explain primary key in sql server?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

How to see existing views in ms sql server?

0 Answers  

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

What is clustered index

0 Answers  

---

Explain how to send email from sql database?

0 Answers  

---

State the difference between local and global temporary tables?

0 Answers  

---

What is the most common trace flags used with sql server?

0 Answers  

---

create index a on employee(dno) In this,which index was created?

2 Answers  

---

How to provide default values to stored procedure parameters?

0 Answers  

---

What is bcp? When does it used?

0 Answers  

---