Not using HediSQL

[SimonSevren]

While running the SQL query on local SQL databse i recive multipal errors: Shouldent this query work on outhers than HeidiSQL?

Or what are the posebilities?

Msg 156, Level 15, State 1, Line 14 Incorrect syntax near the keyword 'IF'. Msg 102, Level 15, State 1, Line 14 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 19 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 35 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 48 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 61 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 85 Incorrect syntax near ''. Msg 195, Level 15, State 7, Line 87 'utf8' is not a recognized SET option. Msg 195, Level 15, State 7, Line 88 'utf8' is not a recognized SET option. Msg 195, Level 15, State 7, Line 90 'utf8' is not a recognized SET option. Msg 102, Level 15, State 1, Line 106 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 120 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 136 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 154 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 174 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 213 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 229 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 258 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 291 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 310 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 327 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 339 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 357 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 380 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 402 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 436 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 456 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 468 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 483 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 494 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 516 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 542 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 555 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 580 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 596 Incorrect syntax near ''. Msg 195, Level 15, State 7, Line 601 'utf8' is not a recognized SET option. Msg 102, Level 15, State 1, Line 616 Incorrect syntax near ''. Msg 102, Level 15, State 1, Line 644 Incorrect syntax near ''. Msg 195, Level 15, State 7, Line 648 'utf8' is not a recognized SET option. Msg 195, Level 15, State 7, Line 654 'utf8' is not a recognized SET option. Msg 195, Level 15, State 7, Line 655 'utf8' is not a recognized SET option. Msg 102, Level 15, State 1, Line 708 Incorrect syntax near ''.