Vasu Gadhiya

Vasu Gadhiya

  • NA
  • 429
  • 102.9k

want to check every record is exist or not in sql

May 9 2014 2:12 AM
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 ?

Answers (1)