Copy CustomerName, CustomerID from Customer table
SELECT CustomerName, CustomerID INTO CustomerCopy
FROM Customer
Copy structure of Customer table
SELECT * INTO CustomerCopy
FROM Customer
WHERE 1 = 2
Saturday, November 21, 2009
Copy a table
at 12:21 AM
Labels: SQL Server, SQL Server Tip
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment