Opening all columns from a Table sorted by specified Column
SELECT * FROM TargetTable ORDER BY ColumnName
Showing posts with label SELECT. Show all posts
Showing posts with label SELECT. Show all posts
Thursday, April 30, 2009
How to copy a table ?
Make a copy of an existing table
SELECT * INTOTargetTable FROM SourceTable
Make a copy of the structure of an existing table
SELECT * INTO TargetTable FROM WHERE 1=0
SELECT * INTO
Make a copy of the structure of an existing table
SELECT * INTO
Subscribe to:
Posts (Atom)