PdfPrep.com

How should you complete the Transact-SQL statement?

DRAG DROP

You need to load data from a CSV file to a table.

How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Example:

BULK INSERT Sales.Orders

FROM ‘\SystemXDiskZSalesdataorders.csv’

WITH (FORMAT=’CSV’);

Exit mobile version