select COUNT(*)会产生下一个错误吗？

Question

我正在使用python的pypyodbc在sql Sever数据库上处理一些SQL批量插入cmds。然而，在我发现的日志中：

    python   load_d 4c24-4ea4   ENTER SQLExecDirect 
        HSTMT               0x000000000336C260
        UCHAR *             0x0000000003A91188 [      67] "\ a        SELECT COUNT(*) \ a        FROM out_table\ a        "
        SDWORD                    67

python   load_d 4c24-4ea4   EXIT  SQLExecDirect  with return code -1 (SQL_ERROR)
        HSTMT               0x000000000336C260
        UCHAR *             0x0000000003A91188 [      67] "\ a        SELECT COUNT(*) \ a    

FROM out_table\ a        "
    SDWORD                    67

DIAG [22003] [Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting expression to data type int. (8115) 

计数(*)会不会返回一个非常大的值来“转义”INT的限制？

Answer 1

是。它可以。为了解决这个问题，微软引入了COUNT_BIG-function请在这里查看详细信息https://docs.microsoft.com/en-us/sql/t-sql/functions/count-big-transact-sql?view=sql-server-ver15