INF: ISQL Does Not Send Carriage Returns to SQL Server (70246)

MORE INFORMATION

ISQL appends a linefeed character at the end of each line of input when sending the data to SQL server. If the input file contained a carriage return-linefeed combination the length of the data stored may appear to be wrong because the carriage return characters are never inserted into the database.

For example if we create a file input.sql as follows:

INPUT.SQL:

INSERT INTO MYTABLE VALUES("123 
456")
go
				

And run it by executing the following from a command prompt:

SQL Server will insert into table MYTABLE 7 bytes: 123 followed by a linefeed, followed by 456")

NOTE: When ISQL is used to select the data that was just entered, and is told to write the data to an output file, the linefeed character that it receives from SQL Server is translated back to a carriage return-linefeed combination.