Loading

want to check every record is exist or not in sql

Vasu Gadhiya

12y1k

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 ?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vasu Gadhiya12y ago
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.