MySQL update to SQL Server syntax error

Question

I'm trying to "convert" this MYSQL query to SQL Server.

update folder_t  a, folder_t  b 
set a.datum_publikace=b.datum_publikace,
    a.datum_expirace=b.datum_expirace,a.nazev=b.nazev 
where a.link=b.idecko and b.linkTyp=0 and a.sekce=20

The current error I am getting:

Incorrect syntax near 'a'.

It is obvious the problem lies in the syntax but really can not find the answer anywhere.

I am a novice when it comes to SQL Server.

If anyone can help out I would really appreciate it.

Lukasz Szozda · Accepted Answer · 2015-12-14 08:39:43Z

3

SQL Server UPDATE syntax:

UPDATE a
SET a.datum_publikace = b.datum_publikace,
    a.datum_expirace  = b.datum_expirace,
    a.nazev           = b.nazev 
FROM folder_t a
JOIN folder_t b 
  ON a.link = b.idecko
WHERE b.linkTyp = 0 
  AND a.sekce = 20;

answered Dec 14, 2015 at 8:39

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3540118 Over a year ago

Thank you very much, it helped a lot

Collectives™ on Stack Overflow

MySQL update to SQL Server syntax error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related