Javier Sobrans

EXEC sp_who2 ALTER DATABASE nombredb SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO RESTORE DATABASE nombredb FROM DISK = 'C:\copiaseg.bak' GO

DBCC CHECKIDENT (tabla, reseed, 0) set identity_insert tabla ON / OFF

Editor Avanzado FastLoadOptions FIRE_TRIGGERS

=SIFECHA(fechanacimiento;hoy;"y")

SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(object_id) LIKE '%CustomerContract%'

Cadena de conexion: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://www.websitewithhtmltable.com/tablepage.html;Extended Properties="HTML Import;HDR=YES;IMEX=1";

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)

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