What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

---

How do indexes help, types?

0 Answers  

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

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

0 Answers  

---

What is the need for group functions in sql?

0 Answers  

---

---

Explain primary key, foreign key and unique key?

0 Answers  

---

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

---

How do you start single user mode in clustered installations?

0 Answers  

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---

List out the differences between global and local temp tables in sql server?

0 Answers  

---

Tell me what is fill factor?

0 Answers  

---

Can you tell me about the concept of ER diagrams?

0 Answers  

---