FIX: BULK INSERT Statement Inserts Records Into Table When FIRSTROW is Greater Than LASTROW

ID: Q225045

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 48052 (SQLBUG_70)

SYMPTOMS

The BULK INSERT statement inserts records into a table instead of returning an error when FIRSTROW is set to a value greater than LASTROW.

WORKAROUND

Set FIRSTROW to a value less than LASTROW.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 7.0. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

MORE INFORMATION

Steps to Reproduce the Behavior


CREATE TABLE bulk_t (c1 int)
GO

BULK INSERT bulk_t FROM 'C:\bulk_t.txt' WITH (firstrow=2, lastrow=1)
GO

-- bulk_t.txt is a text file with numbers 1 through 10 on each line

SELECT * FROM bulk_t
GO

The fixed behavior in SQL Server 7.0 Service Pack 1 is that when the preceding BULK INSERT statement is executed, it runs successfully and the following message is returned:


   The command(s) completed successfully.

However, no records are inserted into the table as none match the specified criteria.

Additional query words: bcp

Keywords : kbbug7.00 kbSQLServ700bug kbSQLServ700sp1fix
Version : winnt:7.0
Platform : winnt
Issue type : kbbug