skip to main | skip to sidebar

asp tech blog

Wednesday, May 27, 2009

insert from selecting from another database

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
Posted by GD_V3 at 7:09 PM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Link

  • Avinash's blog

Blog Archive

  • ►  2010 (4)
    • ►  November (1)
    • ►  October (1)
    • ►  August (1)
    • ►  February (1)
  • ▼  2009 (6)
    • ►  November (2)
    • ▼  May (2)
      • list<> sort or order using limbda expression
      • insert from selecting from another database
    • ►  April (2)
  • ►  2008 (3)
    • ►  October (1)
    • ►  April (1)
    • ►  January (1)
  • ►  2007 (10)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  August (5)
    • ►  July (1)
  • ►  2006 (11)
    • ►  November (1)
    • ►  October (1)
    • ►  May (4)
    • ►  April (2)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2005 (19)
    • ►  December (1)
    • ►  November (1)
    • ►  September (4)
    • ►  August (2)
    • ►  July (3)
    • ►  April (1)
    • ►  March (1)
    • ►  February (2)
    • ►  January (4)
  • ►  2004 (15)
    • ►  December (8)
    • ►  November (7)

About Me

GD_V3
View my complete profile