How to delete all rows with truncate table statement in ms sql server?
- 1 Answers
- 1076 Views
- I also Faced
- E-Mail Answers
Answer Posted / Shobhit Kumar Gupta
The TRUNCATE TABLE statement is used to remove all records from a table. It deallocates the space occupied by the table but does not reinitialize the object identification (ObjectID) values, unlike DELETE.n`nTRUNCATE TABLE YourTableName;n`
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I find query history in sql server?
What is acid mean in sql server?
How do I start sql server 2017?
What are the kinds of subquery?
When should you use an instead of trigger?
Explain “row_number()” in sql server with an example?
Why should you use or avoid select * statements?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is normalization and what are the advantages of it?
How to convert numeric expression data types using the cast() function?
What is the difference between for xml raw and for xml auto?
Explain system functions or built-in functions? What are different types of system functions?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
what is spatial nonclustered index
How to convert character strings into numeric values?
