Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22404 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / firoz shaikh
If identity is set on column and current identity col is 10
then if truncate and delete is done then for truncate
identity col will be 1 and for delete then it will be 11.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
how would you troubleshoot blocking? : Sql server database administration
What is the difference between Normalization and De-normalization?
Describe in brief sql server monitoring ways.
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
In which tcp/ip port does sql server run? Can it be changed?
Explain different types of lock modes in sql server 2000?
What is 1nf normalization form?
How can I know what locks are running on which resource?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What are the differences between DDL, DML and DCL in SQL?
How to sort query output in descending order in ms sql server?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Write a code to select distinct records without using the DISTINCT keyword.
How to copy the tables, schema and views from one sql server to another?
