In this example, Transact-SQL will create a new table with all columns from the rows in "old_table" in which the last name starts with "Ja." Advertisement. Article continues below this ad.

Learn about the common issues that arise when using table variables in SQL Server and how to improve your query performance ... You also cannot create indexes, constraints, or triggers on table ...