bulkinserts.sql

来自「PURPOSE OF THE PROJECT: This Applicatio」· SQL 代码 · 共 48 行

BULK INSERT  MEGAMARTAUDIO.DBO. MMA_USERS_TB
FROM 'D:\GROUP 5\Database\USERS TABLE VALUES.TXT'
WITH
(
    DATAFILETYPE='CHAR',
    FIELDTERMINATOR=',',
    ROWTERMINATOR=';'
)
SELECT * FROM MMA_USERS_TB





BULK INSERT  MEGAMARTAUDIO.DBO. MMA_PRODUCTS_TB
FROM 'D:\GROUP 5\Database\PRODUCTS TABLE VALUES.TXT'
WITH
(
    DATAFILETYPE='CHAR',
    FIELDTERMINATOR=',',
    ROWTERMINATOR=';'
)



BULK INSERT  MEGAMARTAUDIO.DBO. MMA_MODELS_TB
FROM 'D:\GROUP 5\Database\MODELS TABLE VALUES.TXT'
WITH
(
    DATAFILETYPE='CHAR',
    FIELDTERMINATOR=',',
    ROWTERMINATOR=';'
)




BULK INSERT  MEGAMARTAUDIO.DBO. MMA_ADS_TB
FROM 'D:\GROUP 5\Database\AD TABLE VALUES.TXT'
WITH
(
    DATAFILETYPE='CHAR',
    FIELDTERMINATOR=',',
    ROWTERMINATOR=';'
)