bulkinserts.sql

PURPOSE OF THE PROJECT: This Application would facilitate the huge process of managing the Ad detai

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=';'
)