How to Create One Table From Another  Database Table in SQL Server
Channel: Data Science Center
Date: 2022-03-17

SELECT * FROM EMP;
GO

SELECT * INTO EMP
FROM [HRDB].[dbo].[EMPLOYEES]
GO

SELECT * FROM EMP;



USE HRDB;
GO

SELECT [CustomerKey], [FirstName],[LastName],   [Gender],[EmailAddress] , [YearlyIncome]
into CUSTOMER
FROM [AdventureWorksDW2017].[dbo].[DimCustomer]
WHERE Gender = 'M';
GO



SELECT * FROM CUSTOMER;
GO