SQLServer imports data from one table to another
Table B data is transferred to Table A
1. If Table A exists
insert into A(a,b,c) (select a,b,c from B)
2. If Form A does not exist
select a,b,c into A from B
If you need to cross databases, command:
select * into BackUpTempDb. [dbo].itsvse from MyDb. [dbo].test
3. If you need to cross databases
insert into library A. [dbo]. Table A(a,b,c) (select a,b,c from library B.[ dbo]. Table B)
The data of the W table of the P library is transferred to the W table of the C library
Example: insert into CbjGameProjectXBDB1_3. [dbo]. WeaponAmmo_EffectSet(a,b,c) (select a,b,c from ProjectOneGameInfo.[ dbo]. WeaponAmmo_EffectSet)
|
Posted on 11/16/2019 2:43:29 PM
|
|
|
