How To Delete All Rows with TRUNCATE TABLE Statement in MS SQL Server?
Submitted by: AdministratorIf you want to delete all rows from a table, you have two options:
* Use the DELETE statement with no WHERE clause.
* Use the TRUNCATE TABLE statement.
The TRUNCATE statement is more efficient the DELETE statement. The tutorial exercise shows you a good example of TRUNCATE statement:
SELECT COUNT(*) FROM ggl_rates
GO
5
TRUNCATE TABLE ggl_rates
GO
SELECT COUNT(*) FROM ggl_rates
GO
0
Submitted by: Administrator
* Use the DELETE statement with no WHERE clause.
* Use the TRUNCATE TABLE statement.
The TRUNCATE statement is more efficient the DELETE statement. The tutorial exercise shows you a good example of TRUNCATE statement:
SELECT COUNT(*) FROM ggl_rates
GO
5
TRUNCATE TABLE ggl_rates
GO
SELECT COUNT(*) FROM ggl_rates
GO
0
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
| ☺ | What Happens If You Insert a Duplicate Key for the Primary Key Column in MS SQL Server? |
| ☺ | What Happens If NULL Values Are Involved in Arithmetic Operations? |
| ☺ | How To Provide Default Values to Function Parameters? |
| ☺ | How To Concatenate Two Binary Strings Together? |
| ☺ | How To Write Character String Constants or Literals in MS SQL Server? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
