Insert Values from One Database Table to another Database Table in SQL Server

In this article we learn how to copy or insert values from one database table to another database table in SQL server suppose to have 10 values then we can do very easy but if we have 10000000 values then it’s very difficult to save from one database table to another database table in SQL server .if you want to only Copy the structure of an existing table into new table with data /without data in SQL Server. And Copy data from one table to another in sql server



INSERT INTO DestinationDatebasename.dbo.DestinationTable(column)
   SELECT (column)
   FROM SourceDatebasename.dbo.SourceTable



Insert Values from One Database Table to another Database Table in SQL Server Insert Values from One Database Table to another Database Table in SQL Server Reviewed by NEERAJ SRIVASTAVA on 8:25:00 PM Rating: 5

No comments:

Powered by Blogger.