Copy / Insert Data from one table to another table in SQL Server

In this video, you can see how to copy / insert data from one table to another table within same database or within two different databases in SQL server. Sometimes it is required that you need to take some backup of one particular table. SQL query is given below: For Same database - select * into dbo.TBL_EMPLOYEE_NEW from dbo.TBL_EMPLOYEE For Two different Database - select * into TEST_DEMO_DB.dbo.TBL_EMPLOYEE_NEW from TEST_DB.dbo.TBL_EMPLOYEE ~-~~-~~~-~~-~ Please watch: "10 Important Question and Answer on Swasthya Sathi স্বাস্থ্যসাথী Scheme - First Phase"    • 10 Important Question and Answer on Swasth...   ~-~~-~~~-~~-~