Answer Posted / harninder

select `salary` from test t1 where 0=(select count(*) from
test where t1.`salary`<`salary`)

How to generate create table script on an existing table in ms sql server?

1090

---

Please differentiate between a local and a global temporary table?

948

---

What is RMS migrations?

2082

---

What are different types of statement?

942

---

Explain subquery and state its properties?

966

---

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

1920

---

What is the difference between for trigger and after trigger?

1022

---

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

1134

---

What is the parse query button used for?

978

---

Define inner join in sql server joins?

986

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

856

---

What is normalization and what are the advantages of it?

919

---

Can you tell me about the concept of ER diagrams?

1016

---

When should you use an instead of trigger?

916

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

971

---