sqlserver how to copy one table for another

Little scum · Posted on 11/18/2017 10:09:28 PM

SQL Server, if the target table exists:
insert into target table select * from original table;

SQL Server, if the target table does not exist:

select * into target table from original table;

In Oracle, if the target table exists:

insert into target table select * from original table;

commit;

In Oracle, if the target table does not exist:

create table target table as select * from original table;

winvfhp · Posted on 11/20/2017 8:27:08 AM

SQL basic writing syntax, not bad...
insert into a1,a2,a3 from tb2 select a1,a2,a3 from tb1

Little scum · Posted on 12/27/2017 10:05:00 PM

insert into Test(uid,AppKey,IsEnable,_CreateTime) select Id,NEWID(),1,GETDATE() from Account;

Insert data into an existing data table

admin · Posted on 1/5/2018 4:07:04 PM

Update one table to another

update Table 1 set Mail = Table 2. Email from Table 1, Table 2 where Table 1. AccountId=Table 2. Id

[Source] sqlserver how to copy one table for another

Related Posts

Sections viewed