Answer Posted / koti-khammam

TRUNCATE: Only data is deleted structure of the table
exists.


DROP: Both data and structure of the table gets removed.

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1385

---

What is a mixed extent?

1025

---

Name three of the features managed by the surface area configuration tool? : sql server security

990

---

What do you understand by SQL*Net?

1032

---

We need to perform what steps in the following order to work with a cursor?

1218

---

How to delete duplicate rows from table except one?

989

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1250

---

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

1965

---

Explain the etl (extraction, transformation, and loading)?

995

---

How to divide query output into multiple groups with the group by clause in ms sql server?

1038

---

what is database replication? : Sql server database administration

1063

---

In how many ways you can invoke ssrs reports?

139

---

Do you know the isolation level that sql server support?

960

---

How can I track the changes or identify the latest insert-update-delete from a table?

961

---

How to get a list of columns in a view using the "sp_help" stored procedure?

1033

---