Javier Sobrans

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

AppendDataBoundItems="True" *asp:ListItem Value=""*Vacio*/asp:ListItem* /

select * from sysobjects where name Like '%tabla/vista%' select syscolumns.name, systypes.name, syscolumns.length from syscolumns inner join systypes on syscolumns.xtype = systypes.xtype where id = 94675435 order by syscolumns.colid

WHERE CONVERT(varchar(12),fecha,101) = CONVERT(varchar(12),DATEADD(day,-1,GETDATE()),101)

Crear disco recuperacion / Mantenimiento Arranque CD/DVD Reparar equipo / simbolo sistema bootrec /fixmbr

jquery jgcharts.js var api = new JGCharts.Api();