In one case, I need to import data from one database to another database, and I've figured out the format should be
insert into server.newdatabase.owner.table
from select * from server.olddatabase.owner.table
the key point here is the four parts name follows the pattern server.database.owner.object
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment