Transact SQL Ejercicios
Transact SQL Ejercicios
Transact SQL Ejercicios
(nombre varchar(45),
lugar varchar(45),
direccion varchar(45),
ciudad varchar(45),
pais char(45),
municipio varchar(45));
USE EstudioSQL;
GO
SELECT c.FirstName, c.LastName, VacationHours, SickLeaveHours,
VacationHours + SickLeaveHours AS 'Total Hours Away'
FROM HumanResources.Employee AS e
JOIN Person.Contact AS c ON e.ContactID = c.ContactID
ORDER BY 'Total Hours Away' ASC;
GO
use dbEstudioSilverlight
DECLARE @RowTo INT;
SET @RowTo = 5;
SELECT @RowTo
GO
SET NOCOUNT ON
DECLARE @startdate datetime, @adddays int
SET @startdate = '1/11/1900 12:00 AM'
SET @adddays = 5
use EstudioSQL
UPDATE dbo.aeropuertos SET nombre=nombre