What does the blue arrow in the SQL analyzer do?
The Execute Query button (a green arrow on my installation) runs the batch of SQL statements in the editing window against the server and database you are connected to (shown in the title bar). If you first highlight some statements in the editing window it will run just the highlighted portion. The Parse Query button (a blue checkmark) validates the syntax of the code but doesn’t actually execute it. The messages “The command(s) completed successfully” / “Query batch completed” are therefore slightly misleading in this case.