Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 135
  • Last Modified:

copy table with data from one database to another

I want to copy table with all records in one database to another database. How can I do it?

thank you

0
guosong
Asked:
guosong
1 Solution
 
Gustavo Perez BuenrostroCommented:
Use INTO clause of SELECT statement. See sample below:

select * into pubs..MySysmessages from master..sysmessages
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now