Dear friends, what's wrong here: (Of course with GO everything OK)
DROP TABLE IF EXISTS #T
GO
CREATE TABLE #T (First int)
INSERT #T SELECT 1
DROP TABLE IF EXISTS #T
-- G_O
CREATE TABLE #T (Second int)
INSERT #T SELECT 2
SELECT * FROM #T
GO
Error:
There is already an object named '#T' in the database.
Of course the error comes from second "CREATE TABLE" because the table was not dropped, but why?
Thank you so much.