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

guosongAsked:
Who is Participating?
 
Gustavo Perez BuenrostroConnect With a Mentor Commented:
Use INTO clause of SELECT statement. See sample below:

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

From novice to tech pro — start learning today.