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 ...

You can use the table variable being passed in as any other table for querying data. Limitations to passing table parameters You must use the READONLY clause when passing in the table valued ...