Hello, I bulk import to a table using the following BULK INSERT dbo.name FROM 'k:\Backup1\name.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) GO The first colum of the table is bigint no null. I want to be incremented automatically without changing the bigint no null. In the txt file what should be the value of this column so that the value of this colum to be the previous value + 1? txt file Name_ID First Last 2,Andrew,Patel 3,George,Walker What character should i put in stead of 2, 3? Thanks in advance,