[Solved] Incorrect syntax near the keyword ‘set’ and ‘as’ [closed]

by


In SQL Server, the update should start:

update TBLSurvey
    set Status = -1
    from TBLSurvey . . .

The syntax for update in SQL Server is here. If I had to guess, it looks like you are confused with aspects of MySQL syntax.

solved Incorrect syntax near the keyword ‘set’ and ‘as’ [closed]