What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

How to find the date and time of last updated table?

3 Answers  

---

How to include date and time values in sql statements?

0 Answers  

---

Which index created when Create Index on table(col), Why

2 Answers   CGI,

---

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

---

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

---

what is trigger . hw will it use them

2 Answers   TCS,

---

What is the distinction amongst delete and truncate?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What is the difference between for auto and for nested?

0 Answers  

---