How can I implement this plan in C# with SQL command?

Question

I have two tables:

Table 1 with columns name_markaz nvarchar(100), code_markaz nchar(20);
Table 2 with columns name_markaz nvarchar(100), code_markaz nchar(20);

I want implement this plan, read all data from table 1 and insert into table 2 with this condition:

if table1.code_markaz not found in table 2.code_markaz then

   insert the table1.code_markaz into the table2.code_markaz

possible duplicate of [Check if table exists in SQL Server](http://stackoverflow.com/questions/167576/check-if-table-exists-in-sql-server) — Artem Kulikov, Aug 08 '15 at 06:53

score 1 · Answer 1 · edited Aug 08 '15 at 07:31

1

I think this query can do that (I prefer using EXISTS):

INSERT INTO table2 (name_markaz, code_markaz)
   SELECT name_markaz, code_markaz 
   FROM table1
   WHERE NOT EXISTS (SELECT 1
                     FROM table2 ti
                     WHERE ti.code_markaz = table1.code_markaz);

edited Aug 08 '15 at 07:31

marc_s

732,580
175
1,330
1,459

answered Aug 08 '15 at 06:51

shA.t

16,580
5
54
111

This is one line command and you can execute it from c# easily ;). – shA.t Aug 08 '15 at 06:59
column list is used and IDENTITY_INSERT is ON. i get that error – behzad razzaqi Aug 08 '15 at 07:12
If you have any IDENTITY column after `SELECT` you should remove them in the insert statements ;). – shA.t Aug 08 '15 at 07:17

How can I implement this plan in C# with SQL command?

1 Answers1

Linked

Related