多个select一个结果集输出

最新推荐文章于 2023-12-01 12:10:33 发布
最新推荐文章于 2023-12-01 12:10:33 发布
阅读量1.4k 收藏
点赞数
分类专栏： sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/CSDNWeiZhiQiang/article/details/89600695
版权 
--dw跑的表
select * from(
select 'ACPT_OCCUR_BILL_DETAIL' as  n ,count(1) as c from ACPT_OCCUR_BILL_DETAIL -- where
union all
select 'ACPT_BALANCE_BILL_DETAIL' as  n ,count(1) as c from ACPT_BALANCE_BILL_DETAIL -- where
union all
select 'PLEDGE_BALANCE_BILL_DETAIL' as  n ,count(1) as c from PLEDGE_BALANCE_BILL_DETAIL -- where
union all
select 'DSCT_OCCUR_BILL_DETAIL' as  n ,count(1) as c from DSCT_OCCUR_BILL_DETAIL -- where
union all
select 'ESCROW_BALANCE_BILL_DETAIL' as  n ,count(1) as c from ESCROW_BALANCE_BILL_DETAIL -- where
union all
select 'FREE_BRANCH_CHRG_DTL' as  n ,count(1) as c from FEE_BRANCH_CHRG_DTL -- where
union all
select 'ISSUE_OCCUR_BILL_DETAIL' as  n ,count(1) as c from ISSUE_OCCUR_BILL_DETAIL -- where
union all
select 'ISSUE_BALANCE_BILL_DETAIL' as  n ,count(1) as c from ISSUE_BALANCE_BILL_DETAIL -- where
union all
select 'PLEDGE_OCCUR_BILL_DETAIL' as  n ,count(1) as c from PLEDGE_OCCUR_BILL_DETAIL -- where
union all
select 'TRANSFER_OCCUR_BILL_DETAIL' as  n ,count(1) as c from TRANSFER_OCCUR_BILL_DETAIL -- where
union all
select 'PLEDGERE_OCCUR_BILL_DETAIL' as  n ,count(1) as c from PLEDGERE_OCCUR_BILL_DETAIL -- where
union all
select 'PLEDGERE_BALANCE_BILL_DETAIL' as  n ,count(1) as c from PLEDGERE_BALANCE_BILL_DETAIL -- where
union all
select 'RDSCT_OCCUR_BILL_DETAIL' as  n ,count(1) as c from RDSCT_OCCUR_BILL_DETAIL -- where
union all
select 'RDSCT_BALANCE_BILL_DETAIL' as  n ,count(1) as c from RDSCT_BALANCE_BILL_DETAIL -- where
union all
select 'FOUND_ACCOUNT_BILL_DETAIL' as  n ,count(1) as c from FOUND_ACCOUNT_BILL_DETAIL -- where
union all
select 'PROMPT_PAYMENT_BILL_DETAIL' as  n ,count(1) as c from PROMPT_PAYMENT_BILL_DETAIL -- where
union all
select 'CLEAR_REG_BILL_DETAIL' as  n ,count(1) as c from CLEAR_REG_BILL_DETAIL -- where
union all
select 'BUYOUT_OCCUR_BILL_DETAIL' as  n ,count(1) as c from BUYOUT_OCCUR_BILL_DETAIL -- where
union all
select 'BUYOUT_BALANCE_BILL_DETAIL' as  n ,count(1) as c from BUYOUT_BALANCE_BILL_DETAIL -- where
union all
select 'ENDOR_BILL_DETAIL' as  n ,count(1) as c from ENDOR_BILL_DETAIL -- where
union all
select 'DSCT_BALANCE_BILL_DETAIL' as  n ,count(1) as c from DSCT_BALANCE_BILL_DETAIL -- where
union all
select 'CLEAR_SETTLE_BILL_DETAIL' as  n ,count(1) as c from CLEAR_SETTLE_BILL_DETAIL -- where
union all
select 'RECOURSE_BILL_DETAIL' as  n ,count(1) as c from RECOURSE_BILL_DETAIL -- where
union all
select 'BRANCH_INFO_DETAIL' as  n ,count(1) as c from BRANCH_INFO_DETAIL -- where
union all
select 'RETURN_DISCOUNT_REDEMPTION_DETAIL' as  n ,count(1) as c from RETURN_DISCOUNT_REDEMPTION_DETAIL -- where
union all
select 'LIFTING_PLEDGE_DETAIL' as  n ,count(1) as c from LIFTING_PLEDGE_DETAIL -- where
union all
select 'GUARANTEE_INFORMATION_DETAIL' as  n ,count(1) as c from GUARANTEE_INFORMATION_DETAIL -- where
union all
select 'DM_ELEC_BUSI_VOL' as  n ,count(1) as c from DM_ELEC_BUSI_VOL -- where
union all
select 'DM_ELEC_ENDORSE_VOL' as  n ,count(1) as c from DM_ELEC_ENDORSE_VOL -- where
union all
select 'DM_DSCT_BALANCE_STATISTICS' as  n ,count(1) as c from DM_DSCT_BALANCE_STATISTICS -- where
union all
select 'DM_BILL_TRAFFIC_VOL' as  n ,count(1) as c from DM_BILL_TRAFFIC_VOL -- where
) a


--交易系统跑的表
select *
from (
select 'ACC_HANG_INF' as  n ,count(1) as c from ACC_HANG_INF -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ACC_INF' as  n ,count(1) as c from ACC_INF -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select'ACC_POST_DTL' as  n ,count(1) as c from ACC_POST_DTL -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ACC_POST_PND_DTL' as  n ,count(1) as c from ACC_POST_PND_DTL -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'FEE_BRANCH_CHRG_DTL' as  n ,count(1) as c from FEE_BRANCH_CHRG_DTL -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'PRM_BRANCH_DEF' as  n ,count(1) as c from PRM_BRANCH_DEF -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'STL_DELIVERY_ORDER' as  n ,count(1) as c from STL_DELIVERY_ORDER -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'STL_DLV_ORDER_SUM' as  n ,count(1) as c from STL_DLV_ORDER_SUM -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'REL_OC_DRAFT_T' as  n ,count(1) as c from REL_OC_DRAFT_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'REL_TRD_DRAFT_T' as  n ,count(1) as c from REL_TRD_DRAFT_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'REL_ZTX_CD_T' as  n ,count(1) as c from REL_ZTX_CD_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'TRD_CLOSING_PRICE_T' as  n ,count(1) as c from TRD_CLOSING_PRICE_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'TRD_DIALOGUE_T' as  n ,count(1) as c from TRD_DIALOGUE_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'TRD_INTENT_RFQ_T' as  n ,count(1) as c from TRD_INTENT_RFQ_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'TRD_MATCH_DIA_T' as  n ,count(1) as c from TRD_MATCH_DIA_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'TRD_ONECLICK_T' as  n ,count(1) as c from TRD_ONECLICK_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'TRD_REPO_DEAL_T' as  n ,count(1) as c from TRD_REPO_DEAL_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'TRD_TD_DEAL_T' as  n ,count(1) as c from TRD_TD_DEAL_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'TRD_ZTX_DEAL_T' as  n ,count(1) as c from TRD_ZTX_DEAL_T -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_ACT_GRNT' as  n ,count(1) as c from CDRS_ACT_GRNT -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_ACT_IMPAWN' as  n ,count(1) as c from CDRS_ACT_IMPAWN -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_ACT_RDMREDSCT' as  n ,count(1) as c from CDRS_ACT_RDMREDSCT -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_ACT_RECOURSE' as  n ,count(1) as c from CDRS_ACT_RECOURSE -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_ACT_RECOURSE' as  n ,count(1) as c from CDRS_ACT_RECOURSE -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_INF_ACUT_COUNT' as  n ,count(1) as c from CDRS_INF_ACUT_COUNT -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_INF_CDINFO' as  n ,count(1) as c from CDRS_INF_CDINFO -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_INF_ECDINFO' as  n ,count(1) as c from CDRS_INF_ECDINFO -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_INF_PAPERINFO' as  n ,count(1) as c from CDRS_INF_PAPERINFO -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_INF_STICKY' as  n ,count(1) as c from CDRS_INF_STICKY -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_OFFLINE_RECOURSE' as  n ,count(1) as c from CDRS_OFFLINE_RECOURSE -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_ORD_OWNCH' as  n ,count(1) as c from CDRS_ORD_OWNCH -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_RPT_MEMBER_ACC' as  n ,count(1) as c from CDRS_RPT_MEMBER_ACC -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_RQ_DSCT' as  n ,count(1) as c from CDRS_RQ_DSCT -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CDRS_RQ_STCHG' as  n ,count(1) as c from CDRS_RQ_STCHG -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'CPES_BANK_DATA' as  n ,count(1) as c from CPES_BANK_DATA -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'PM_INF_ACCOUNT' as  n ,count(1) as c from PM_INF_ACCOUNT -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'PM_INF_BRANCH' as  n ,count(1) as c from PM_INF_BRANCH -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'PM_INF_BRANCHMERGE' as  n ,count(1) as c from PM_INF_BRANCHMERGE -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'PM_INF_GRANT' as  n ,count(1) as c from PM_INF_GRANT -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'PM_INF_MEMBER' as  n ,count(1) as c from PM_INF_MEMBER -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'PM_MAG_BRANCHGRANT' as  n ,count(1) as c from PM_MAG_BRANCHGRANT -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'PM_MAG_GENDICT' as  n ,count(1) as c  from PM_MAG_GENDICT -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'PM_MAG_GENDICT_NLS' as  n ,count(1) as c from PM_MAG_GENDICT_NLS -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'PM_PARAMETER_SYSTEM' as  n ,count(1) as c from PM_PARAMETER_SYSTEM -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
) b


select current_date;
--ecds跑的表

select * 
from (
select 'ECDSNODT0101' as  n ,count(1) as c from ECDSNODT0101  -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0202' as  n , count(1) as c from ECDSNODT0202 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0206' as  n , count(1) as c from ECDSNODT0206 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0208' as  n , count(1) as c from ECDSNODT0208 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0210' as  n , count(1) as c from ECDSNODT0210 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0211' as  n , count(1) as c from ECDSNODT0211 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0214' as  n , count(1) as c from ECDSNODT0214 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0601' as  n , count(1) as c from ECDSNODT0601 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0605' as  n , count(1) as c from ECDSNODT0605 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0201' as  n , count(1) as c  from ECDSNODT0201 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0203' as  n , count(1) as c from ECDSNODT0203 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0204' as  n , count(1) as c from ECDSNODT0204 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0205' as  n , count(1) as c from ECDSNODT0205 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0207' as  n , count(1) as c from ECDSNODT0207 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0209' as  n , count(1) as c from ECDSNODT0209 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0212' as  n , count(1) as c from ECDSNODT0212 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0213' as  n , count(1) as c from ECDSNODT0213 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0215' as  n , count(1) as c from ECDSNODT0215 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0216' as  n , count(1) as c from ECDSNODT0216 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0606' as  n , count(1) as c from ECDSNODT0606 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
union all
select 'ECDSNODT0702' as  n , count(1) as c from ECDSNODT0702 -- where to_date(insert_date, 'yyyy-mm-dd') = current_date
) s
WeiZhiQiang&xqp
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mysql 多个 SELECT 查询的结果集放多个字段
Programming Talk
04-10 557
在MySQL中，通常我们进行多个SELECT查询时，结果会分别返回，但如果希望将多个查询的结果集合并到一个结果集中，且每个查询结果作为一行的不同字段展示，这就需要使用一些特殊的SQL技巧或者编程语言（如PHP、Python等）对查询结果进行处理。以上代码将会把两个查询的结果合并到一个数组中，虽然不是同一个“字段”，但在逻辑上它们位于同一“行”。如果确实需要将多个独立的查询结果合并到单行的不同字段，且查询之间并无关联，那么可能就需要借助于程序逻辑来实现了。以下是一个示例，假设我们有两个表​。
多个查询语句能否一次把结果导出_SQL系列文章(四)：复杂查询
weixin_39523887的博客
12-09 1020
你好，我在学习SQL(Structured Query Language)，并通过写文章的方式整理和输出所学，这是第四篇，题目是《复杂查询》，主要内容是子查询。这是我通过navicat客户端创建的表，为了显示全部数据导出为excel格式，后面会从这个表中查询数据什么是子查询呢？当查询语句当中嵌套查询语句，前者就被称为主查询，后者被称为子查询——它也是一个完整的查询语句。什么时候要用子查询呢？当想要...
《SQL必知必会》第十四课 组合查询 利用UNION操作符将多条SELECT语句组合成一个结果集
堵心好似八局
12-08 1531
第十四课 组合查询 #利用UNION操作符将多条SELECT语句组合成一个结果集 一、组合查询 二、创建组合查询 参考文献： 【1】《SQL必知必会》第四版 人民邮电出版社 [美] Ben Forta 著 钟鸣 刘晓霞 译
多个SELECT语句的结果合并在一起并展示
最新发布
weixin_55747284的博客
12-01 967
可以使用数据库中的联合查询（UNION）来同时展示多个查询的结果，联合查询可以将多个SELECT语句的结果合并在一起。这个语句将会把table1和table2中的column1和column2列合并在一起返回，如果需要保留重复值，可以使用UNION ALL。如果需要对查询结果进行排序，可以在最后添加ORDER BY子句，例如。这个语句将会把table1和table2中的column1和column2列合并在一起返回，并按照column1列降序排序，如果有相同的值再按照column2列升序排序。
怎么将多个select的结果合并成一张表
weixin_42587866的博客
12-31 3081
可以使用 UNION 操作符将多个 SELECT 语句的结果合并为一张表。 例如，如果你有两个 SELECT 语句，分别查询两张表中的数据： SELECT * FROM table1; SELECT * FROM table2; 你可以使用 UNION 操作符将它们合并为一张表： SELECT * FROM table1 UNION SELECT * FROM table2; 这样就可以得到一...
SELECT 结果集处理
weixin_48943299的博客
01-31 242
ORM 框架怎么处理数据库返回的数据？要点在于，将列映射过去字段（借助于元数据），然后将每一列 的数据解析为字段的类型（这个过程在 Go 里面是由 sql 包完成的），利用反射将转化后的数据塞到结构 体里。unsafe 的过程则类似，不同在于，unsafe 是先在目标地址创建了字段的零值，后面 sql 包把数 据注入到这些地方使用 unsafe 有什么优点？性能更好ORM 的性能瓶颈在哪里，以及怎么解决？两个：构造 SQL 的过程，和处理结果集。前者主要通过 buffer pool 能够极大缓解；
PHP调用MsSQL Server 2012存储过程获取多结果集(包含output参数)的详解
10-27
为了处理多结果集，我们需要使用`nextRowset()`方法来切换到下一个结果集： ```php $stmt->execute(); $rowset_1 = $stmt->fetch(PDO::FETCH_ASSOC); print_r($rowset_1); echo ' <br>'; $stmt->nextRowset(); $...
mysql存储过程之返回多个值的方法示例
09-08
在这个存储过程中，我们为每个订单状态创建了一个独立的SELECT查询，并使用`INTO`关键字将查询结果赋值给对应的OUT参数。这样，当存储过程执行完毕后，调用者可以通过这些参数获取订单统计信息。 在PHP中调用这个...
thinkphp调用sqlserver储存过程返回多个结果集
12-20
- 在存储过程中，如果需要返回多个结果集，必须在每个结果集之后使用`SELECT * FROM (VALUES(1)) AS tmp`这样的语句作为分隔。这样，当通过PHP调用存储过程时，可以逐个处理每个结果集。 - 如果遇到无法获取结果集...
存储过程的输出参数，返回值与结果集
09-11
在创建存储过程时，可以声明一个或多个输出参数，并在过程内部设置它们的值。例如，在SQL Server中，我们可以声明一个名为`@Rowcount`的输出参数，如下面的示例所示： ```sql CREATE PROCEDURE Employee @Rowcount...
商业编程-源码-一个执行SYBASE SQL语言的工具示例源代码.zip
06-24
4. **结果集处理**：执行SQL查询后，通常会返回一个结果集。源代码中应有处理结果集的逻辑，可能是将结果输出到控制台，或者保存到文件或内存数据结构中。 5. **错误处理**：在执行SQL语句时，可能会遇到各种错误，...
多个select运算
gaoxiang24的博客
05-23 628
witht1as( --第一个查询 ), t2as( --第二个查询 ), t3as( --第三个查询 )， ......... selectt1.ID,t1.num-t2.num + t3.numfromt1,t2,t3wheret1.ID=t2.IDand t1.ID = T3.ID ...
多个参数的select方法调用
03-31 858
SQL （十三）组合查询(union操作符把多条select语句组合为一个结果集)
wulimmya的博客
07-01 3081
文章目录创建组合查询示例：多条where语句和union实现达到相同效果union规则对组合查询结果排序 - 组合查询也叫并，复合查询。 有多个where子句的select语句可以作为一个组合查询。 创建组合查询 示例：多条where语句和union实现达到相同效果 先看两个查询 第一个查询出Illinois、Indiana和Michigan三个州（美国）的所有顾客的三项信息 select cust_name, cust_contact, cust_email from Customers where
多个select 多个列_你还在 Select * 吗？
weixin_39860919的博客
12-10 131
点击上方“后端技术精选”，选择“置顶公众号”技术文章第一时间送达！题外话，开发中遇到问题或者学习新技术时缺少交流环境，可以点击加入【后端技术交流群】应用程序慢如牛，原因多多，可能是网络的原因、可能是系统架构的原因，还有可能是数据库的原因。那么如何提高数据库SQL语句执行速度呢？有人会说性能调优是数据库管理员(DBA)的事，然而性能调优跟程序员们也有莫大的关系。程序中嵌入的一行行的SQL语...
SQL优化的步骤
weixin_30367873的博客
07-08 261
一、优化SQL的方法 SQL优化的一般步骤：先查询mysql数据库运行状况，然后定位慢查询，再分析sql的执行过程，然后进行优化 1.使用show status查询数据库的运行状况 //显示数据库运行状态 SHOW STATUS //显示数据库运行总时间 SHOW STATUS LIKE 'uptime' //显示连接的次数 SHOW STATUS LIKE 'co...
将多个Selcet结果一起输出
RENYUAN
08-23 605
<br />select count(*) from table1 union all<br /> select count(*) from table2 union all<br /> select count(*) from table3;
sqlserver多个select结果融合在一个查询中汇总返回
u011511086的专栏
04-23 1144
select --图片下载数 (select count(1) FROM [down_img_record]) as imgDown -- 视频下载数 ,(select count(1) FROM [down_video_record]) as videoDown --领导图下载数 ,(select count(1) FROM [down_img_record] m left join img_info i on i.id=m.img_id where i.exist_leader=1) as lea
sqlServer 存储过程输出多行结果集如何定义？
05-03
在 SQL Server 存储过程中，可以使用多个 SELECT 语句来返回多个结果集。可以使用如下代码定义一个存储过程，输出两个结果集： ``` CREATE PROCEDURE [dbo].[TestMultiResultSet] AS BEGIN -- 第一个结果集 SELECT * FROM Table1 -- 第二个结果集 SELECT * FROM Table2 END ``` 在执行该存储过程时，可以使用多个结果集读取器来获取多个结果集的数据。例如，使用 C# 代码获取多个结果集的数据： ``` using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand("TestMultiResultSet", connection); command.CommandType = CommandType.StoredProcedure; connection.Open(); SqlDataReader reader1 = command.ExecuteReader(); while (reader1.Read()) { // 处理第一个结果集的数据 } reader1.NextResult(); while (reader1.Read()) { // 处理第二个结果集的数据 } reader1.Close(); } ```

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值