—————————————————-
Method : 1
—————————————————-
USE PropertyIdea
GO
—-Create Table
CREATE TABLE Country (CountryID int, Country nvarchar(50),Code int)
—-INSERT INTO Country using SELECT
INSERT INTO Country (CountryID , Country ,Code)
SELECT CountryID , Country ,Code
FROM [Kunj.Corp].[dbo].[Country]
—-Verify that Data in Country
SELECT * FROM Country
—————————————————-
Method : 2
—————————————————-
USE PropertyIdea
GO
—-Create Table
CREATE TABLE Country (CountryID
int, Country nvarchar(50),Code int)
—INSERT INTO Country using SELECT
INSERT INTO Country (CountryID, Country ,Code)
SELECT CountryID , Country ,Code
FROM [Kunj.Corp].[dbo].[Country]
—-Verify that Data in Country
SELECT * FROM Country
