Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
4 Cards in this Set
- Front
- Back
|
bcp utility
|
bulk copies data between an instance of sql server and a data file in a user-specified format. requires No knowledge of TSQL except when used w/ the queryout option.
|
|
|
bulk insert
|
imports a data file into a database table or view in a user - specified format
|
|
|
bulk insert restriction
|
specify only update 1024 fields, this is the maximum number of columns allowed in a table. the bcp utility does not have this limitation.
|
|
|
OPENROWSET(bulk..) function
|
allows you to access remote data by connecting to a remote data source through an OLE DB provider, supports table hints.
|
