Introduction: In this post I will explain how we can insert the Data of one Table to Another Table in different Database in Sql Server.
In the last article I have explained How to insert data of one Table to Another Table in Sql.
SELECT * INTO DATABASE NAME1.TABLE NAME FROM DATABASE NAME2.TABLE NAME
Here DATABASE NAME1.TABLE NAME denotes that Database in table have to Cretaed.
DATABASE NAME2.TABLE NAME denotes the Database and Table Name from which Data will be copy.
SELECT * INTO Testing.dbo.COPY_DETAIL FROM TestBlog.dbo.BOOK_DETAIL
You see a Table name COPY_DETAIL will Created in Testing Database.
Related Articles on Sql Server:
How to insert data of one Table to Another Table in Sql
If yes post your comment to admire my work. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.
Is it helpful?
What do you think about this article?
If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.