WiredWorx || Web design || SEO || Bournemouth

Web design, website development and search engine optimisation (SEO) in Bournemouth, Dorset, UK.

Home · Website and SEO · SQL Server

Copy a table (including data)

19.02.2009. 12:13

SELECT *
INTO [aaa]
FROM [bbb]

and voila - the data will be copied from one table into the, newly created, other (the tables can also be prefixed with "[user]." )