Sunday, July 5, 2015

How to copy a table, with its data, in SQL Server (no, Mgt Studio doesn't do it for you)

You would really think that this would be a built-in feature available from the context menu.  But as proof it most definitely is NOT, see:

As Microsoft tells you, just do this:

SELECT * INTO BizDev.CurrCustomers FROM Sales.Customers

No comments: