Wednesday, 22 December 2010

BCP QUERYOUT WITH FIRSTROW, LASTROW, BATCHSIZE ETC

BCP QUERYOUT WITH FIRSTROW, LASTROW, BATCHSIZE ETC

BCP "SELECT COLUMNNAME from DBNAME.dbo.TABLENAME (nolock)" queryOut "c:\backup\TABLENAME.txt" -c -T -F 1 -L 57318503 -b 50000 -S "PC123"

BCP "SELECT COLUMNNAME from DBNAME.dbo.TABLENAME (nolock)" queryOut "c:\backup\TABLENAME.txt" -c -T -F 57318504 -L 114637007 -b 50000 -S "PC123"