You can the run the rowcount command to confirm that the Numbers match.
您可以执行rowcount命令来确认这两个数字是相同的。
Go to the root directory of the data movement and run the rowcount script.
进入数据转移的根目录并运行rowcount脚本。
When complete, you see four files in the migr folder: geninput, rowcount, timetrac.tables (where timetrac is the database name), and unload.
在完成之后,您会在migr文件夹看到4 个文件:geninput、rowcount、timetrac.tables(其中timetrac是数据库名称)和unload。
To get @@error and @@rowcount at the same time, include both in same statement and store them in a local variable. SELECT @RC = @@ROWCOUNT, @ER = @@ERROR
为了在同一时间获得@@Error和@@Rowcount,我们应将二者包括在同一语句中并将它们存储在局部变量中。
Each import can read a different section of the same input file because the import command allows you to specify "SKIPCOUNT m ROWCOUNT n" to read rows m+1 to m+n from the input file.
每个导入命令可以读取一个输入文件的不同片段,因为导入命令允许指定 “SKIPCOUNTmROWCOUNTn”来读取输入文件中的m+1到 m+n行。
Each import can read a different section of the same input file because the import command allows you to specify "SKIPCOUNT m ROWCOUNT n" to read rows m+1 to m+n from the input file.
每个导入命令可以读取一个输入文件的不同片段,因为导入命令允许指定 “SKIPCOUNTmROWCOUNTn”来读取输入文件中的m+1到 m+n行。
应用推荐