How to Create One Table From Another Database Table in SQL Server

Published: 17 March 2022
on channel: Data Science Center

7,021

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

Watch video How to Create One Table From Another Database Table in SQL Server online, duration hours minute second in high quality that is uploaded to the channel Data Science Center 17 March 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 7,021 times and liked it 25 visitors.

426