Answer Posted / ashish jain

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a

select empname from emp where count(empname)>1

What is server-level principal?

122

---

What is normalization and its types?

1076

---

What is sql server 2000 work load governor?

1158

---

How to create user messages with print statements in ms sql server?

1030

---

How to add the custom code in Report?

129

---

Explain a differential backup?

1060

---

What is query processing?

989

---

Explain indexed views?

1028

---

What are sql server functions?

1028

---

What are sql servers used for?

1111

---

What is identity?

1080

---

What is Extended user-defined?

1029

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1005

---

What are the advantages of the mirroring?

1148

---

What is resource db in sql server?

1056

---