Answer / mohammadali.info

*The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.

*TRUNCATE removes all rows from a table. The operation cannot be rolled back. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.

*The DROP command removes a table from the database. All the tables' rows,
indexes and privileges will also be removed. The operation cannot be rolled back.

*DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.

IF Answer is Correct Pls give Rate

Answer / krishna

DELETE,DROP,TRUNCTATE are to use the remove the rows from the table

DELETE: Delete is used to delete the rows from table by using where condition also and we can ROLLBACK it also

DROP: Delete rows permanently and we can not ROLLBACK it.

TRUNCATE : Delete the data not the structure means in this delete only data but structure is same

Where are stored procedures in sql server?

0 Answers  

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

Why would you use sql agent?

0 Answers  

---

How to convert binary strings into integers in ms sql server?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

---

Give an example of SQL injection attack ?

0 Answers   HAL,

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

---

What are views in ms sql server?

0 Answers  

---

What are temporal tables in sql server 2016?

0 Answers  

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---