Answer Posted / bala

-- to find third highest salary from emp table
select empname,empsal from emp a where 3 = (select count(*)
from emp b where a.empsal <= b.empsal);

How do you Implement SSIS Packages in your Project?

1872

---

What factors you will consider calculating the storage requirement for that view?

897

---

Explain the database you used in your final year project?

974

---

List out the differences between global and local temp tables in sql server?

1003

---

Explain concepts of analysis services?

893

---

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

1924

---

What is order of B+tree?

1063

---

Will sql server 2005 allow you to reduce the size of a column?

920

---

Tell me extended events in sql server 2008?

951

---

Which sql server table is used to hold the stored procedure scripts?

1027

---

What do you mean by sql server 2005 express management tools?

1253

---

How to use wildcard characters in like operations in ms sql server?

1065

---

What are the types of subscriptions in SQL Server replication?

963

---

How to select true false based on column value in sql server?

956

---

What the different topologies in which replication can be configured?

1025

---