BCP - OUT - IN - Bulk Insert

BULK insert t_Export from 'c:\t_Export.txt' with (batchsize=10000,tablock,FIELDTERMINATOR='\t',keepidentity)
GO
BCP "select * from dbname.dbo.TableName_0 (nolock) where [Date] between '2010-05-01' and '2010-05-31 23:59:59.997' " queryOut D:\dbname_TableName201005.txt -c -T
pause
Exit

BCP dbname.dbo.TableName_0 Out D:\dbname_TableName200912.txt -c -T
pause
Exit


BCP dbname.dbo.TableName_0 in D:\dbname_TableName201005.txt -c -T -E -- E Stand for Identity_Insert ON
Pause
Exit


SET identity_insert TableName_0 on
bulk insert dbname.dbo.TableName_0 from 'D:\dbname_TableName201005.txt' with (FIELDTERMINATOR = ',')
SET identity_insert TableName_0 off

GO

SET identity_insert TableName_0 on
bulk insert dbname.dbo.TableName_0 from 'D:\dbname_TableName201005.txt' with (FIELDTERMINATOR = '\t')
SET identity_insert TableName_0 off

GO

SET identity_insert TableName_0 on
bulk insert dbname.dbo.TableName_0 from 'D:\dbname_TableName201005.txt' with (batchsize=10000,tablock,FIELDTERMINATOR='\t')
SET identity_insert TableName_0 off

GO
SET identity_insert TableName_0 on
bulk insert TableName_0 from 'D:\dbname_TableName201005.txt' with (batchsize=10000,tablock,FIELDTERMINATOR='\t',Firstrow=2)
SET identity_insert TableName_0 off