Devart Forums

Posted: **Thu 18 Jul 2013 15:53**

Hi, I am creating TSQL UPDATE command where i need to compare two tables field by field and set changes, but suggest info does not work.

Example of TSQL UPDATE:

Code: Select all

 UPDATE dbo.tbl1
 SET
    field1 = tbl2.field1
    Here suggest list is not working, when I am writing text there is no field list
  ...
  FROM
    tbl1
    JOIN tbl2
      ON tbl1.ID = tbl2.ID 

  WHERE
  tbl1.field1 <> tbl2.field1 OR
  ...

Thank you for advice
L

Posted: **Fri 19 Jul 2013 07:57**

Please check that you have selected the correct database in the 'Database' dropdown menu on the 'SQL' toolbar.

Also, please make sure you put a comma after:

Code: Select all

field1 = tbl2.field1

Devart Forums

dbForge Studio issue

dbForge Studio issue

Re: dbForge Studio issue