I want to be able to execute one statement in a script in the Editor without having to highlight that query. Is there a sort of execute at cursor key?
Why can I not execute at cursor even with delimiter and ; set?
F9 is really executing current batch instead of current statement, since you cannotknow when a statement terminates, as somebody could use ; while somebody else uses a carriage return, etc.Settinga statement terminating delimited may also conflict with the execution of a full script since these maybe encountedalso.
How 4.0 executesis the correct behavior. There is no execute statement at cursor option.
To execute, insertGObetween statementsand runthat statement with F9, or highlight the single statement and run with F9 or F5.
Enhancement request ST54439 has been submitted to development for consideration in a future release of Toad for SQL Server