Answer Posted / raman sharma

For third highest salary u can use this syntax

select min(cin) from ( select distinct cin from
cws.usertable order by cin desc ) where rownum<4

How to add more data to the testing table in ms sql server?

1000

---

Why do we use stored procedures in sql server?

895

---

Call by value and call by reference in procedure and function, with NOCOPY.

1245

---

Explain the architecture of ms sql reporting service?

872

---

What do you understand by sql server agent?

906

---

can you instantiate a com object by using t-sql? : Sql server database administration

961

---

Find first and last day of current month in sql server

976

---

How to rebuild master databse?

1029

---

What are the transaction properties?

963

---

Explain active/passive and active/active cluster configurations?

1014

---

How to execute a sql statement using mssql_query()?

977

---

Is INSTEAD OF trigger directly applicable to Table ?

958

---

What happens to a trigger with multiple affected rows?

865

---

What is factless fact table? : sql server analysis services, ssas

963

---

SQL Server Architecture ?

2397

---