– FLASH-JET –

— Create TEMP Table Local — Disappears when windows of query is closed.  CREATE TABLE #tmp_table  ( id   INT, NAME VARCHAR(20) ) SELECT 1      AS ID, ‘John’ AS NAME — Create And Insert Into Temp…

  This demo s pretty self explained, you just copy and paste it into SQL Management studio: DECLARE @cmd NVARCHAR(30) = ‘SELECT * FROM Person.Address’ EXEC (@cmd) go — Using Dynamic SQL With Parameter DECLARE @cmd_param VARCHAR = 1 DECLARE @cmd VARCHAR(100) = N’Select * from employees where employeeid = ‘   + @cmd_param…