How to Create One Table From Another Database Table in SQL Server
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