Sql

Search

sql select data from one database and insert into a different database

USE TargetDatabase
GO

INSERT INTO dbo.TargetTable(field1, field2, field3)
   SELECT field1, field2, field3
     FROM SourceDatabase.dbo.SourceTable
     WHERE (some condition)

Comment

PREVIOUS	NEXT

Code Example
Sql :: delete duplicate data from table
Sql :: bigquery function
Sql :: mysql extract days
Sql :: reseed sql identity
Sql :: get id from just inserted row mysql server python
Sql :: smalldatetime in sql
Sql :: IlluminateDatabaseQueryExceptionSQLSTATE[HY000] [2002] No such file or directory
Sql :: spark sql grows beyond 64 kb
Sql :: select all domains of database firbird
Csharp :: how to make an object look at another unity
Csharp :: dropdown text mesh pro unity
Csharp :: c# print hello world
Csharp :: unity how to convert mouse screen position to world position
Csharp :: how do i convert to base64 c#
Csharp :: how to set serial number in gridview in asp net
Csharp :: unity get all by tag
Csharp :: unity mouse position to world
Csharp :: unity reload scene
Csharp :: wpf bind to self
Csharp :: Retrieve url path
Csharp :: base64 to image c#
Csharp :: c# append to file
Csharp :: 3(x-4)-2(3x+4)=4(3-x)+5x+4
Csharp :: csharp string to double
Csharp :: unity check when clicked on object
Csharp :: check animation end unity
Csharp :: unity detect number key
Csharp :: c# right click event
Csharp :: alert message in c# windows application
Csharp :: how to get executable path in wpf

Search

SQL

sql select data from one database and insert into a different database

ADD CONTENT