Javier Sobrans

c:\sqlcmd -E -S (local) -Q "BACKUP DATABASE basedadatos TO DISK='C:\Seg\basededatosBACKUP.bak'"

SELECT name, size FROM sys.database_files; USE Base_datos GO CHECKPOINT GO CHECKPOINT GO CHECKPOINT GO BACKUP LOG Base_datos WITH TRUNCATE_ONLY GO DBCC SHRINKFILE (basedatos_db_log)

exec sp_configure 'show advanced options',1; reconfigure; exec sp_configure 'Ad Hoc Distributed Queries',1; reconfigure; SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 Xml;HDR=YES;Database=C:\telefonos.xlsx', 'SELECT * FROM [Hoja1$]') Instalar: Microsoft Access Database Engine 2010 Redistributable

declare @datos table (iddevice int null, SerialNumber varchar(100) null, Estado varchar(50) null, Factura varchar(30)) insert into @datos select id_device, SerialNumber, click_TipoEstado.Name,null from tabla_Devices inner join tabla_TiposEstado on tabla_Devices.FK_id_DeviceEstado = tabla_TiposEstado.id_Estado update @datos set Factura = InvoiceNumber from Facturas where fk_id_device = iddevice and YEAR(invoicedate) = 2011 and MONTH(invoicedate) = 5 select Estado, COUNT(Estado) as Cuantos, COUNT(Factura) as Facturados from @datos group by Estado select * from @datos where Estado = 'Funcionando' and Factura is null

Salvador Sobrans Camí 24/7/1929 - 1/5/2011

NotesSQL 1.-AuthenticationList, añadir usuarios. 2.-Notes.ini añadir NCMenu. 3.-Path, añadir C:\NotesSQL\;C:\Lotus\Notes\;

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