Copy from 1 SQL table to another?
19 August 2003, 11:27 AM
#2
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
rik,
easiest way is to do
INSERT INTO <table2> FROM SELECT * FROM <table1>
if you have an identity field then you will need to issue a SET IDENTITY INSERT <table2> OFF (or maybe ON cant remember!)
Gary
easiest way is to do
INSERT INTO <table2> FROM SELECT * FROM <table1>
if you have an identity field then you will need to issue a SET IDENTITY INSERT <table2> OFF (or maybe ON cant remember!)
Gary
Thread
Thread Starter
Forum
Replies
Last Post
JonMc
Subaru Parts
22
06 February 2016 09:50 PM
ossett2k2
Engine Management and ECU Remapping
15
23 September 2015 09:11 AM
pimmo2000
Computer & Technology Related
2
21 September 2015 12:04 PM