How to create a Temp Table in SQL Server using an EXEC statement?
What happens when you try the following inside a SQL Server Strored Procedure?
EXEC (‘CREATE TABLE #TEMPTABLE‘+‘123‘+‘(firstColumn varchar(10), secondColumn varchar(20), thridColumn int)‘)
INSERT INTO …