TOP

Sql bulk insert – update column value with same content

************

update Appearances_Sync_Admarc2 set REP_NBR=SUBSTRING(REP_NBR,1,4)

*******

BULK INSERT Order_Sync
FROM ‘c:\meWORK2\meOrder3.txt’
WITH
(
FIELDTERMINATOR = ‘|’,
ROWTERMINATOR = ‘\n’
)

Comments are closed.