want to check every record is exist or not in sql

Question

Hi i want to check every record if it exist or not in sql insert into MYDB.dbo.Table1 select * from MYDB.dbo.Table2 AS tmp WHERE NOT EXISTS (select c1 From MYDB.dbo.Table1 where c1= '1115.15-F/C') it copy all record. i want to copy all record of only 1115.15-F/C How can i do ?

Vasu Gadhiya · Answer

ok i Find Solution My Self. IF not EXISTS (SELECT * FROM MYDB.dbo.Table1 WHERE c1= '1115.15-F/C' ) BEGIN insert into MYDB.dbo.Table1 select * from MYDB.dbo.Table2 where c1= '1115.15-F/C' END ELSE BEGIN print 'already exist' END Thanks.