Слайд 2Вставка данных
INSERT VALUES
INSERT SELECT
SELECT INTO
BULK INSERT
![Вставка данных INSERT VALUES INSERT SELECT SELECT INTO BULK INSERT](/_ipx/f_webp&q_80&fit_contain&s_1440x1080/imagesDir/jpg/924517/slide-1.jpg)
Слайд 3bulk insert Persons from 'd:\1.txt’
with
(DataFileType = 'char’,
FieldTerminator = ',’,
RowTerminator = '\n')
![bulk insert Persons from 'd:\1.txt’ with (DataFileType = 'char’, FieldTerminator = ',’, RowTerminator = '\n')](/_ipx/f_webp&q_80&fit_contain&s_1440x1080/imagesDir/jpg/924517/slide-2.jpg)
Слайд 4Удаление данных
DELETE
DELETE JOIN
TRUNCATE
![Удаление данных DELETE DELETE JOIN TRUNCATE](/_ipx/f_webp&q_80&fit_contain&s_1440x1080/imagesDir/jpg/924517/slide-3.jpg)
Слайд 5Обновление данных
UPDATE
UPDATE JOIN
![Обновление данных UPDATE UPDATE JOIN](/_ipx/f_webp&q_80&fit_contain&s_1440x1080/imagesDir/jpg/924517/slide-4.jpg)