Answer / v.krishnakumar

in truncate we can delete inside the table data not the
structure of the table,in delete operation we can remove
our data in the table as well as structure but we can get
again using rollback operation, in drop operation it was
permanentely removed from our database we cannot get agian.

Answer / aman sharma

truncate are the use to the remove the data as well all the space into the table , and the delete are use to the delete only for the data into the table,and the drop is use to the delete or remove the table....

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

---

What is the maximum row of a size?

0 Answers  

---

Is mysql the same as sql server?

0 Answers  

---

what is the difference between sql query and google query?

10 Answers   TCS,

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

What is microsoft sql server?

0 Answers  

---

What is stored procedures?

0 Answers  

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

0 Answers  

---

What is the difference between truncate and delete commands?

0 Answers  

---

About DTS usage ?

2 Answers   Cognizant, Wipro,

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---