Execute sp_executeSql for select…into #table but Can’t Select out Temp Table Data

by

Using a global temporary table in this scenario could cause problems as the table would exist between sessions and may result in some problems using the calling code asynchronously.

A local temporary table can be used if it defined before calling sp_executesql e.g.

CREATE TABLE #tempTable(id int);

execute sp_executesql N'INSERT INTO #tempTable SELECT myId FROM myTable';

SELECT * FROM #tempTable;

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. T-SQL split string
  3. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  4. How can I get column names from a table in SQL Server?
  5. Conditional WHERE clause in SQL Server
  6. How can I select the first day of a month in SQL?
  7. Split function equivalent in T-SQL?
  8. Is the NOLOCK (Sql Server hint) bad practice?
  9. Multi-statement Table Valued Function vs Inline Table Valued Function
  10. Remove trailing zeros from decimal in SQL Server
  11. Select statement to find duplicates on certain fields
  12. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  13. Where value in column containing comma delimited values
  14. Parse comma-separated string to make IN List of strings in the Where clause
  15. SQL query to split column data into rows
  16. Compare DATETIME and DATE ignoring time portion
  17. How to create a PivotTable in Transact/SQL?
  18. Split function in SQL Server 2008
  19. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  20. SQL “between” not inclusive
  21. T-SQL and the WHERE LIKE %Parameter% clause
  22. Can I set ignore_dup_key on for a primary key?
  23. Using PIVOT in SQL Server 2008
  24. Which SQL query is faster? Filter on Join criteria or Where clause?
  25. Generate all combinations in SQL
  26. How can I group by date time column without taking time into consideration
  27. Average of multiple columns
  28. SQL Server SELECT INTO @variable?
  29. Using CASE Statement inside IN Clause
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment