Answer Posted / vidyalakshmi.s

select * from emp1 where salary in (select salary from emp1
group by salary having count(salary) >1)

Do you know the isolation level that sql server support?

938

---

What is tcl in sql server?

1088

---

What are policy management terms?

949

---

What are the new features of sql server 2012 reporting service?

129

---

What do you understand by the data quality services in sql server?

918

---

What is function of ROLLUP ?

1053

---

When columns are added to existing tables, what do they initially contain?

997

---

What is efficiency data?

922

---

What is default constraint in ms sql server?

979

---

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

920

---

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

910

---

List out the difference between union and union all in sql server?

942

---

How do you create an execution plan?

908

---

what is create database syntax? : Sql server database administration

1063

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

929

---