|
SELECT * INTO CustomersBackup2017
|
using this customers table get a backup wwith name
customersbackup2017
|
|
FROM Customers;
|
|
|
SELECT * INTO CustomersBackup2017 IN 'Backup.mdb'
|
customers table copied to another database with name changing
|
|
FROM Customers;
|
|
|
SELECT CustomerName, ContactName INTO CustomersBackup2017
|
how to copy the only two columns and change the table name of
copied file
|
|
FROM Customers;
|
|
|
SELECT * INTO CustomersGermany
|
|
|
FROM Customers
|
copy the whole table means some rows only where rows are matched
|
|
WHERE Country = 'Germany';
|
|
|
SELECT Customers.CustomerName, Orders.OrderID
|
|
|
INTO CustomersOrderBackup2017
|
|
|
FROM Customers
|
|
|
LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
|
|
Tuesday, 9 June 2020
how can I copy the database file or move the table or change the database folder
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment