|
Video Description
OPENROWSET is a T-SQL command frequently used to fetch data from linked servers, but it can also be used to read data from a file. In this video you will learn how to use OPENROWSET to import data from a file into a table. You will also learn how to use the IDENTITY_INSERT option, and the hints IGNORE_TRIGGERS, and IGNORE_CONSTRAINTS to control how the import affects identity columns, firing of triggers, and constraint checking.
Total Time: 11 Minutes 04 Seconds Video: 3 of 14
|