import one table from one database to another database

if i have one table from database A, and i want to copy the table to database B, then how to do it in SQL server management studio express? is it i have to make sql query?

try

select * into databaseB.dbo.TableA
from databaseA.dbo.TableA

or go to database B and run

select * into TableA
from databaseA.dbo.TableA

This will not copy constraints only data.

if it will not work right click on database and from task select import or export and select source destination , table to copy and run created SSIS package.

|||

i don't try yet the query. anyway, i right click on the database but i don't find any task that saying select import or export?

|||

i don't try yet the query. anyway, i right click on the database but i don't find any task that saying select import or export?

|||

Right click on your database in Object Explorer and in menu select tasks and next import export, Sorry it does not work in Management studio express, nut if you have SP1 and integration developments studio installed you can do it inside it.