I have a text file that I want to import into a table using BULK INSERT. I each entire row in the text file to go into one column in my database table. Do I set the FIELDTERMINATOR and ROWTERMINATOR both to "\n"?
Books Online says not to use the same value for ROWTERMINATOR and FIELDTERMINATOR
Also, is there any documentation that indicates what these mean:
\t (I know is tab)
\n (I know is New Line)
\r\n (Don't know wtf this is)