How to delete duplicate rows in sql server?

0 Answers  

---

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

0 Answers  

---

How many types of Outer Joins?What are they?

1 Answers  

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

---

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

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

Explain primary key and foreign key constraints?

0 Answers  

---

Explain multiserver query

0 Answers  

---

Is truncate autocommit?

0 Answers  

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

What is an identity column in insert statements?

0 Answers  

---