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 does set rowcount do?

896

---

Will count(column) include columns with null values in its count?

1082

---

What do you mean by acid?

983

---

What area unit the various kinds of info compression introduced in sql server 2008?

1071

---

How do I start sql server agent automatically?

958

---

How ssrs maintain security?

1077

---

Name three of the features managed by the surface area configuration tool? : sql server security

983

---

What is the latest version of microsoft sql server?

1036

---

How to access the inserted record of an event?

1043

---

What is an expensive query?

922

---

What are the different methods available under sqlcommand class to access the data?

1111

---

What are the different types of locks in the database?

918

---

What is the difference between for trigger and after trigger?

1098

---

How to provide values to stored procedure parameters in ms sql server?

1026

---

What is the difference between set and select?

1084

---