Answer Posted / vidyalakshmi.s

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

if no size is defined while creating the database, what size will the database have? : Sql server administration

1010

---

How to recreate an existing index in ms sql server?

1057

---

Name and describe few console utilities for ssrs?

284

---

What is report rendering ?

157

---

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

1042

---

Do you know what are the steps to process a single select statement?

975

---

Name 3 ways to get an accurate count of the number of records in a table?

1039

---

What are database states in ms sql server?

1180

---

How will you hide an attribute? : sql server analysis services, ssas

958

---

Can we write trigger for view?

1013

---

Explain the purpose of indexes?

977

---

What are audit control procedures?

990

---

What are the advantages of partitioning?

1130

---

Why use “nolock” in sql server?

1059

---

What are the different authentication modes in sql server?

1119

---