Tutorial by Examples

This code selects data out of a table and displays it in the query tool (usually SSMS) SELECT Column1, Column2, Column3 FROM MySourceTable; This code inserts that data into a table: INSERT INTO MyTargetTable (Column1, Column2, Column3) SELECT Column1, Column2, Column3 FROM MySourceTable;

This code selects data out of a table: SELECT Column1, Column2, Column3 FROM MySourceTable; This code creates a new table called MyNewTable and puts that data into it SELECT Column1, Column2, Column3 INTO MyNewTable FROM MySourceTable;

To move data you first insert it into the target, then delete whatever you inserted from the source table. This is not a normal SQL operation but it may be enlightening What did you insert? Normally in databases you need to have one or more columns that you can use to uniquely identify rows so we w...