Ir al contenido principal

Entradas

Mostrando entradas de 2010

Reducir LOG SQL

USE basedatos CHECKPOINT EXEC sp_addumpdevice 'disk', 'CopiaBaseDatos', 'F:\Backups\DDBB4.bak' BACKUP DATABASE basedatos TO CopiaBaseDatos BACKUP LOG basedatos TO CopiaBaseDatos WITH TRUNCATE_ONLY DBCC SHRINKFILE (basedatos_log)

SQL UPDATE

USE AdventureWorks; GO UPDATE Sales.SalesPerson SET SalesYTD = SalesYTD + SubTotal FROM Sales.SalesPerson AS sp JOIN Sales.SalesOrderHeader AS so ON sp.SalesPersonID = so.SalesPersonID AND so.OrderDate = (SELECT MAX(OrderDate) FROM Sales.SalesOrderHeader WHERE SalesPersonID = sp.SalesPersonID); GO --- USE AdventureWorks; GO UPDATE Sales.SalesPerson SET SalesYTD = SalesYTD + (SELECT SUM(so.SubTotal) FROM Sales.SalesOrderHeader AS so WHERE so.OrderDate = (SELECT MAX(OrderDate) FROM Sales.SalesOrderHeader AS so2 WHERE so2.SalesPersonID = so.SalesPersonID) AND Sales.SalesPerson.SalesPersonID = so.SalesPersonID GROUP BY so.SalesPersonID); GO -fuente: Microsoft