| ||||
Re: Setear campo identity Truncando la tabla (Truncate table #temporal) para eliminar los registros o bien utilizando la instruccion dbcc checkindent(tabla, reseed, valor a fijar)
__________________ La sencillez y naturalidad son el supremo y último fin de la cultura... -- MCTS : SQL Server 2008, .NET Framework 3.5, ASP.NET Applications. |
| ||||
Re: Setear campo identity Hola Andresillo, gracias por contestar Si hago Truncate table #temporal exactamente que es lo que estoy haciendo? eliminando los registros? cual es la diferencia con ejecutar un delete from #temporal? |
| ||||
Re: Setear campo identity De Books online de SQL Server...
Código:
TRUNCATE TABLE Removes all rows from a table without logging the individual row deletes. Remarks TRUNCATE TABLE is functionally identical to DELETE statement with no WHERE clause: both remove all rows in the table. But TRUNCATE TABLE is faster and uses fewer system and transaction log resources than DELETE. The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table's data, and only the page deallocations are recorded in the transaction log. TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, indexes and so on remain. The counter used by an identity for new rows is reset to the seed for the column. If you want to retain the identity counter, use DELETE instead. If you want to remove table definition and its data, use the DROP TABLE statement. You cannot use TRUNCATE TABLE on a table referenced by a FOREIGN KEY constraint; instead, use DELETE statement without a WHERE clause. Because TRUNCATE TABLE is not logged, it cannot activate a trigger. TRUNCATE TABLE may not be used on tables participating in an indexed view.
__________________ La sencillez y naturalidad son el supremo y último fin de la cultura... -- MCTS : SQL Server 2008, .NET Framework 3.5, ASP.NET Applications. |
| ||||
Re: Setear campo identity je je, gracias, aunque en estos momentos no estoy en condiciones como para traducir y aprender algo más sobre sql server Una pregu mas, que va en el segundo parametro de dbcc checkindent(tabla, reseed, valor a fijar) |
| ||||
Re: Setear campo identity TRUNCATE resetea el IDENTITY, DELETE no A tu última pregunta, generalmente va 1, a menos que quieras comenzar en otro número.
__________________ Friedrich Nietzsche |