Explain the difference between primary keys and foreign keys?

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 to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,

---

Explain transaction server distributed transaction?

0 Answers  

---

Can a trigger be created on a view?

0 Answers  

---

how can u get last observation in an unknown dataset ?

0 Answers   Genpact,

---

How can you fetch alternate records from a table?

0 Answers  

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---

Explain isolation levels that sql server supports?

0 Answers  

---

What are the difference between primary key and unique key? : sql server database administration

0 Answers  

---

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  

---