Answer Posted / jiten

select top 1 salary from employee where salary in (select
top n salary from employee order by salary desc)

Will the writetext statement activate a trigger?

641

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

576

---

How to delete multiple rows with one delete statement in ms sql server?

597

---

Differentiate between ms sql server reporting services vs crystal reports?

574

---

Name some of the open source software that you can use in alternative to SSR?

121

---

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

650

---

List the ways in which dynamic sql can be executed?

723

---

What is update_statistics command?

659

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

675

---

What are different types of replication in sql server?

660

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

687

---

Explain collation?

696

---

How check triggers in sql server?

587

---

what is denormalization? : Sql server database administration

568

---

Explain Geometry datatype in sql server 2008 with example

673

---