INSERT INTO table2 (FID , Fname, Subject) SELECT FID , Fname, Subject FROM table1
Select FID , Fname, Subject into AnotherTable FROM [Learn].[dbo].[Fdetail] where Subject IN('DBMS')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)