使用isql Sybase的行计数

作者: trpnest
发布时间: 2025-02-06 03:08:23 (20天前)
转自：

3 条回复

0#
回复此人
谦成 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 您可以像这样使用count（*）： </p> <pre> <code> set nocount on go select count(*), 'tablename1' from dbname.owner.tablename1 go select count(*), 'tablename2' from dbname.owner.tablename2 go select count(*), 'tablename3' from dbname.owner.tablename3 go </code> </pre> <P> 或者你可以使用统计数据来快速获得价值： </p> <pre> <code> use dbname go set nocount on go select row_count(db_id(), object_id('tablename1')), 'tablename1' from owner.tablename1 go select row_count(db_id(), object_id('tablename2')), 'tablename2' from owner.tablename2 go select row_count(db_id(), object_id('tablename3')), 'tablename3' from owner.tablename3 go </code> </pre> </DIV>

编辑
1#
回复此人
没身份别烦我 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 类似于@aF所写，但更精致。 </p> <pre> <code> select count(*) as rCount, 'tablename1' as tableName from tablename1 union select count(*), 'tablename2' from tablename2 union select count(*), 'tablename3' from tablename3 </code> </pre> </DIV>

编辑

登录后才能参与评论