Copy a table from one database to another database in SQL

Open a new query window in SQL server Management studio. in which database you want to copy a  table. Type

select* 
into new_name_of_table 
from old_database.table_name.

such as:
select* into Appointments from IEMS2.dbo.Appointments

Popular posts from this blog

WPF Crystal Report Viewer Using SAP

mvc razor textboxfor change event change another textboxfor value

ASP.NET MVC razor SAP Crystal report