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)
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]." )