Am using a DECLARE and SET statement to define @end_dt as CAST(...) but, in DBeaver if i end my DECLARE statement, and my SET statements with an ; it treats those statements as if separate from the following main query and gives me a scalar variable error. Once I remove the statement terminators (;) then it runs.
This is my first month using DBeaver. Is there a setting that allows use of statement terminators smoothly?