Why this behavior with SqlServer
IF @xx = 1
SELECT 1 INTO #tbl FROM x
ELSE
SELECT 2 INTO #tbl FROM y
error : Table #tbl already exists
Why this behavior with SqlServer
IF @xx = 1
SELECT 1 INTO #tbl FROM x
ELSE
SELECT 2 INTO #tbl FROM y
error : Table #tbl already exists