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

It is also useful if you are running SQL statements from an SQL application in another SQL-based database. The second form uses a LIKE clause to create a table that has the same column names and ...