Answer Posted / justus

create table emp

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

select empname from emp group by empname having count(empname)>1

What is meant by referential integrity?

968

---

What is the temp table?

885

---

Explain different backup plans?

898

---

can SSRS reports Cache results?

144

---

What is the difference between executequery () and executeupdate ()?

989

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

914

---

What are filegroups in sql server?

1029

---

Ms sql server index?

1029

---

What is the difference between a fill factor of 100 and 0?

938

---

Explain alternate key, candidate key and composite key in sql server?

876

---

How to include text values in sql statements?

1002

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

977

---

what are isolation levels? : Sql server database administration

936

---

What is normalization 1nf 2nf 3nf?

1024

---

what is the primary use of the model database? : Sql server administration

991

---