Рет қаралды 249
Aprende a crear una tabla a partir de otra tabla en SQL Server con Transact-SQL
Aqui te estaré dejando el código utilizado en el video
USE northwind
SELECT *
INTO copia_Employees
FROM dbo.Employees
SELECT LastName, FirstName, Title, City
INTO copia_Employees_2
FROM dbo.Employees
SELECT City, COUNT(*) AS quantity
INTO copia_Employees_3
FROM dbo.Employees
GROUP BY city
SELECT LastName, FirstName, TerritoryID
INTO copia_Employees_4
FROM dbo.Employees AS a
JOIN
dbo.EmployeeTerritories AS b
ON
a.EmployeeID = b.EmployeeID