Software Developer, Equity Analyst, Polymath.
Posts tagged dynamic query
Create temporary table in dynamic query
013 years
by Ray Tawil
in MS Sql Server
there are cases when you are forced to create temporary table in dynamic query.
below is sample of creating temporary then select it in dynamic query.
declare @tableName varchar(30) set @tableName = 'TableB' declare @query nvarchar(4000) set @query = 'CREATE TABLE #'+@tableName+' ( id int, data varchar(30) ) insert into #'+@tableName+' values(1, ''Me'') SELECT * from #'+@tableName exec sp_executesql @query