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 ''.