Javier Sobrans

=(CELDA)/(1440*60) Formato Hora

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";