What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

how can i lock the column in the table

2 Answers   Accenture,

---

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  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

what is the difference between count(*) and count(1) ?

0 Answers   MCN Solutions,

---

Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,

---

What command is used to create a database in the sql server and how?

0 Answers  

---

What is the difference between clustered index and primary key?

0 Answers  

---

How to create function with parameter in sql server?

0 Answers  

---

What is the difference between having and where clause?

4 Answers  

---

Difference between Inner vs outer joins?

0 Answers  

---