Contribute to Ebony7/SQL-SERVER-DOMAIN development by creating an account on GitHub.

A TRUNCATE statement is preferred since it just drops all data pages associated with the table, does not fire table triggers, and resets IDENTITY columns. In the case above, I resorted to using DELETE ...

para borrar todos los registro de una tabla se usa "delete" sin condición "where". También podemos eliminar todos los registros de una tabla con "truncate table". Por ejemplo, queremos vaciar la tabla ...

In general truncate and reload is the easiest option - for the reason that you don't have to worry about what's changed and any back door updates to the source database will be reflected in the ...