SQL Server copy table from one database to another

SQL Server copy table from one database to another

Hello everyone, I am going to share the T-SQL query for copy table from one database to another database using SQL Server 2012. The query detail as given below.

Table of Content
  1. Syntax for copy table from one database to another.
  2. Query for copy table from one database to another.
Syntax

/* COPY TABLE DATA FROM ONE DATABASE TO ANOTHER DATABASE IN SQL SERVER 2012 */
SELECT * INTO DB1.dbo.[Employee] FROM DB2.dbo.[User]

Query for copy table from one database to another

/* COPY TABLE DATA FROM ONE DATABASE TO ANOTHER DATABASE */
SELECT * INTO OBPC.[dbo].[User]
     FROM MASTER.[dbo].[User]

You can use the Wizard method to generate SQLServer scripts and for Wizard you can follow below links.






ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
http://www.code-sample.com
http://www.code-sample.xyz

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.