Copying table

How we can Copy a table(with data) from one databse into another database at the same server

Quote:

Originally Posted by sajithamol

How we can Copy a table(with data) from one databse into another database at the same server

Hi,
you can copy the data by going to enterprise manager and right click on the table .go to tasks. then select import data. then follow the steps.|||

Quote:

Originally Posted by sajithamol

How we can Copy a table(with data) from one databse into another database at the same server

If you want to do that using queryanalyzer

1.Run the following query in Master database
select * into ToDatabase.dbo.Employee from FromDataBase.dbo.Employee