Answer / valarmathi

truncate delete all records from the table and it is auto
commit. We can't able to rollback the data after performing
truncate operation.

delete statement delete the specific or all records from
the table. But we can able to rollback the deleted record

Answer / rajiv singh

Truncate deletes all rows from table. But Delete deletes
row/rows by condition.

Answer / sreejith s t

Both Truncate and delete deletes the rows from a table .
But we cant use where clause in truncate statement . While
doing delete operation all the deleted rows are logged in
the transaction log . It reduces the perfomance . In
truncate operation no transaction logging is happening .
Delete is Autocommited but Truncate is Not .

Answer / ismail hasan

truncate deletes records from a table and while truncating a
table, the table will be dropped from the database and will
again be created automatically. No where clause is
acceptable in truncate statement and one can't restore the
previous data (i.e no rollback is possible) into the table.
It's an efficient process.

Delete statement will delete a particular row(s) on your
choice.

Answer / vasu

Both Truncate and delete deletes the rows from a table .
But we cant use where clause in truncate statement . While
doing delete operation all the deleted rows are logged in
the transaction log . It reduces the perfomance . In
truncate operation no transaction logging is happening .
Delete is Autocommited but Truncate is Not .

Answer / balaji t

Identity counter can be reset in truncate whereas it is not possible in delete.Truncate dont activate trigger whereas delete can be used in triggers.truncate is a DDL command whereas delete is a DML command.

How to name query output columns in ms sql server?

0 Answers  

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

Why is the need for data conversion transformations?

0 Answers  

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

How to list all objects in a given schema?

0 Answers  

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

What are distinctive joins find as a part of sql?

0 Answers  

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,