MySQL query to SQL Server query

Question

I defined sql query and it runs with no problem on MySQL (I am using MySQL) , but when I am trying to execute it on client site (they uses SQL Server) I am getting "Error: Incorrect syntax near 'si'." error message

Hope someone can help me to define right syntax.

The query is following:

update stepinstance si
     inner join cesteplink l on si.id = l.stepinstance_id 
     inner join prompt p on si.prompt_id = p.id
set si.principal_id = 29160180  
where l.case_id = 29179541 
  and si.principal_id = 1799409 
  and si.status = 'In Progress'

Vamsi Prabhala · Accepted Answer · 2015-11-04 20:49:27Z

2

set has to be before the join conditions.

update si
set si.principal_id = 29160180 
from stepinstance si
inner join cesteplink l on si.id = l.stepinstance_id 
inner join prompt p on si.prompt_id = p.id 
where l.case_id = 29179541 
and si.principal_id = 1799409 
and si.status = 'In Progress'

answered Nov 4, 2015 at 20:49

Vamsi Prabhala

49.4k4 gold badges41 silver badges64 bronze badges

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

1 Comment

Saidamin Usmanov Over a year ago

Thanks, it works. I am using Squirrel to run quesrie, and was confused when it complained to "from", I just ignored and run, and it update record

Collectives™ on Stack Overflow

MySQL query to SQL Server query

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