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

by

[ad_1]

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.

[ad_2]

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