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 the order by used for?

1015

---

What are the 7 disadvantages to a manual system?

977

---

What type of Index will get created after executing the above statement?

1090

---

Explain view in sql server?

1051

---

How do you start single user mode in clustered installations?

934

---

Describe triggers features and limitations?

985

---

Which is better statement or preparedstatement?

920

---

How to optimize stored procedures in sql server?

1176

---

optimization techinques

2665

---

Explain what is sql server english query?

1038

---

List the different types of joins?

974

---

What is the new security features added in sql server 2014? : sql server security

991

---

What is indexed view?

974

---

Does a full backup include transaction log?

960

---

How to replace given values with null using nullif()?

981

---