Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 16011 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
IN MSSQLSERVER TRUNCATE RESETS IDENTITY VALUE OF COLUMN
WHILE DELETE DOESN'T RESETS IDENTITY VALUE OF COLUMN
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How would you extract DDL of a table without using a GUI tool?
when does an alert gets signaled?
what is ora 24313?what is the procedure to exclude that error?
Why does Oracle not permit the use of PCTUSED with indexes?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What types of replication are supported in sql server? : sql server DBA
internal architecture
what is logical system in sap basis
How to start SQL Server in minimal configuration mode?
What is replication? : sql server DBA
how can you find out if a table can be redefined?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
how can you enable flashback feature?
What the different types of replication and why are they used? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
