| Author |
 Topic  |
|
|
oukuri
Starting Member
India
7 Posts |
 Posted - 12/18/2012 : 02:25:32
|
Hi i am trying to use 'Insert Bulk' like
Insert Bulk newpersontable select
FIRST_NM,
LST_NM,
MIDDLE_NM,
GNDR,
STU_ID,
CMP_ID,
CALNETUID,
UC_LOC,
ANID
from PERSON
But facing below error
.Net SqlClient Data Provider: Msg 4022, Level 16, State 1, Line 1
Bulk load data was expected but not sent. The batch will be terminated.
Can any one tell how to correct this
oukuri |
|
|
bandi
Flowing Fount of Yak Knowledge
India
1711 Posts |
Posted - 12/18/2012 : 02:29:01
|
If both table newpersontable, person tables are in same database and same instance, then
Insert INTO Bulk newpersontable
SELECT FIRST_NM, LST_NM, MIDDLE_NM, GNDR,STU_ID,CMP_ID,CALNETUID,UC_LOC, ANID
from PERSON
--
Chandu |
Edited by - bandi on 12/18/2012 02:35:29 |
 |
|
|
oukuri
Starting Member
India
7 Posts |
Posted - 12/18/2012 : 05:37:11
|
Incorrect syntax near the keyword 'Bulk'.
oukuri |
|
|
|
bandi
Flowing Fount of Yak Knowledge
India
1711 Posts |
Posted - 12/18/2012 : 05:38:28
|
quote:
Originally posted by oukuri
Incorrect syntax near the keyword 'Bulk'.
oukuri
Strike out that part, then execute...
Insert INTO newpersontable
SELECT FIRST_NM, LST_NM, MIDDLE_NM, GNDR,STU_ID,CMP_ID,CALNETUID,UC_LOC, ANID
from PERSON
If the tables are in different servers, then you have to use linked server..
--
Chandu |
Edited by - bandi on 12/18/2012 05:46:46 |
|
|
| |
Topic |
|
|
|
Using Insert Bulk
