What is replication with database mirroring? : sql server database administration

0 Answers  

---

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

---

Is it true, that there is no difference between a rule and a check constraint?

0 Answers  

---

How adventureworkslt tables are related?

0 Answers  

---

How to use subqueries in the from clause in ms sql server?

0 Answers  

---

---

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

---

What is the difference between Procedure and Function

4 Answers   Accenture, Nagarro, TCS,

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

Why use update_statistics command in sql server?

0 Answers  

---

What is a ddl statement?

0 Answers  

---

Explain indexes disadvantages?

0 Answers  

---

check, not null,unique

2 Answers   IBM,

---