Answer / deepthi

Is a system function that returns the last-inserted
identity value

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

difference between truncate, delete aur drop?

2 Answers  

---

Questions on identity?

2 Answers   Infosys,

---

Can we check locks in database? If so, how can we do this lock check?

0 Answers  

---

What are indexers?

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  

---

What are binary string data types in ms sql server?

0 Answers  

---

What is the difference between resultset and resultsetmetadata?

0 Answers  

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  

---

What is ems sql management studio? : sql server management studio

0 Answers  

---

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

---