 Related Questions Both will result in deleting all the rows in the table EMP.Answered by Scott on 2005-05-12 10:31:58: The difference is that the TRUNCATE call cannot be rolled back and all memory space for that table is Latest Answer : CREATE TABLE ABC
(
Col1 INT
)INSERT INTO ABC VALUES (1)
BEGIN TRAN
TRUNCATE TABLE ABC
ROLLBACK TRAN
SELECT * FROM ABCIn this way, I am able to roll back truncate command. So in
SQL server we can Roll Back TRUNCATE Command. ... TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE. Latest Answer : SQL Sever:Truncate:Delete all the records from the table.Do not keep the deleted record in the log file.Reset the identity column to 1.Use fewer locks with table level locking.Tollback is not possibleDelete trigger does not gets firedAll the pages used ... MONTHS_BETWEEN Latest Answer : In SQL 7.0, 2000Select days=datediff(dd,'1-1-2008','1-31-2008')Result 30 days ... Latest Answer : Single row subqueries returns only one row of results.A single row sub query uses a single row operator; the common operator is the equality operator(=). A Scalar subquery returns exactly one column value from one row.Scalar subqueris can be ysed ... Is there any query which is use to find the case sensitivity in each records in database through visual basic? Latest Answer : Below are the few difference between Stored Procedure and TriggersBoth are stored objects and stored in data base dictionariesStored Procedure- Can pass parameters- Manual execution requiredTriggers:- No parameters can be passed - Automatical executed when ... not known Latest Answer : SQL Server is a product name for micro$ofts relational databaseSQL stands for Structured Query Language and is a set based langauge used to extract and manipulate data in a relational database ... Read Answers (6) | Asked by : priyank singh pathania Co-related sub query is one in which inner query is evaluated only once and from that result outer query is evaluated.Nested query is one in which Inner query is evaluated for multiple times for gatting Latest Answer : If the evaluation of an inner querry(a sub querry) depends on a variable which gets its value in an outer querry,such a subquerry has to be evaluated for each value of the variable.Such a querry is a correlated subquerry.If no such variable is used,the ... Read Answers (4) | Asked by : Chirag What is difference between Oracle and MS Access? What are disadvantages in Oracle and MS Access? What are features&advantages in Oracle and MS Access? Read Answers (9) | Asked by : Balaji G Latest Answer : Eqiui join is totally differene from unions Equijoin depends on a condition involving columns of both tables but where as in Union you can specify a condition based on a columns of the individual tables ... Read Answers (3) | Asked by : Dimple
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
