Hello all,
I'm new to Databricks and can't figure out why I'm getting an error in my SQL code.
Error in SQL statement: ParseException: [PARSE_SYNTAX_ERROR] Syntax error at or near 'if'.(line 1, pos 0) == SQL == if OBJECT_ID('tempdb.#InitialData') IS NOT NULL ^^^ DROP TABLE #InitialData
We run this code at my organization in Microsoft SQL so I know that code itself works, so why am I getting this error when I try to run it in a Notebook?