SELECT INTO a table variable in T-SQL

by

Try something like this:

DECLARE @userData TABLE(
    name varchar(30) NOT NULL,
    oldlocation varchar(30) NOT NULL
);

INSERT INTO @userData (name, oldlocation)
SELECT name, location FROM myTable
INNER JOIN otherTable ON ...
WHERE age > 30;

More Related Contents:

  1. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  2. SQL Server – error when creating stored procedure
  3. How can foreign key constraints be temporarily disabled using T-SQL?
  4. How can I escape square brackets in a LIKE clause?
  5. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  6. When should I use a table variable vs temporary table in sql server?
  7. Datatype for storing ip address in SQL Server
  8. Is there a way to loop through a table variable in TSQL without using a cursor?
  9. Maximum size of a varchar(max) variable
  10. best way to convert and validate a date string
  11. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  12. How do I format a number with commas in T-SQL?
  13. How can I INSERT data into two tables simultaneously in SQL Server?
  14. Is there a way to simplify a NULL compare of 2 values
  15. TSQL Try / Catch within Transaction or vice versa?
  16. What is the maximum number of characters that nvarchar(MAX) will hold?
  17. TSQL: Create a view that accesses multiple databases
  18. Sequence as default value for a column
  19. Aggregate bitwise-OR in a subquery
  20. How do I flush the PRINT buffer in TSQL?
  21. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  22. OR Operator Short-circuit in SQL Server
  23. How to change default language for SQL Server?
  24. T-SQL incrementing counter based on change in a column value
  25. Cannot bulk load. Operating system error code 5 (Access is denied.)
  26. comparing a column to a list of values in t-sql
  27. Does query plan optimizer works well with joined/filtered table-valued functions?
  28. Random record from a database table (T-SQL)
  29. What are row, page and table locks? And when they are acquired?
  30. time format in SQL Server

Leave a Comment