Reindexar bases de datos sql server
REINDEXAR LAS TABLAS DE UNA BASE DE DATOS
DECLARE @TableName varchar(200)
DECLARE TableCursor CURSOR FOR
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Reindexando ' + @TableName
DBCC DBREINDEX (@TableName)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
PONER LOS ID A CERO
DBCC CHECKIDENT ([tabla], RESEED, 0)
Recuperar Lista de Precio
DECLARE @Producto AS nvarchar(25)
DECLARE ProdInfo CURSOR FOR SELECT [Producto] FROM Productos
OPEN ProdInfo
FETCH NEXT FROM ProdInfo INTO @Producto
WHILE @@fetch_status = 0
BEGIN
INSERT INTO Precios (Lista,Producto,Porcentaje,Precio) values (1,@Producto,0,0)
FETCH NEXT FROM ProdInfo INTO @Producto
END
CLOSE ProdInfo
DEALLOCATE ProdInfo
Related Post
Consultas Sql Gestion
COMANDO MYSQL
Service Broker
