Answer / nikhila reddy

6. select top,ditinct,aggregations
steps to execute a query

1. from table1 joins table2
2. on condition
3. where condition
4. group by condition
5. having condition
7. orderby

these way we write the query,
while executing a query internally itwill puul data from table 1 and placed in temp1 as same table2 into temp2
result in temp3.then it checks where conditon and place in temp4 so on.........

what is diffence between replicaion and logshipping?

1 Answers  

---

Explain cross join or cartesian product in sql?

0 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

what's sql server? : Sql server database administration

0 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

What do you understand by the denormalisation?

0 Answers  

---

Define union, union all, minus, intersect?

0 Answers  

---

What stored by the model? : sql server database administration

0 Answers  

---

Explain nested trigger in sql?

0 Answers  

---

System variable and temporary variables

0 Answers   Wipro,

---

Explain user defined views?

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  

---