Which is default field terminator for bulk insert in SQL Server ?
A. Comma
B. Full stop
C. Parenthesis
D. Brackets
Answer:A
Which is default field terminator for bulk insert in SQL Server ?
A. Comma B. Full stop C. Parenthesis D. Brackets
Explanation:Field Terminator is used to delimit columns in the source file.There are some cases where i have seen “|” also. “,” can be part of Name. So in that case the bulk insert may fail.