两个SQL语句

最新推荐文章于 2023-01-11 09:33:13 发布

dianhuanzi3763

最新推荐文章于 2023-01-11 09:33:13 发布

阅读量112

点赞数

原文链接：http://www.cnblogs.com/antony1029/archive/2006/11/21/567021.html

版权

在查询分析器里，查看Query 的 Display Estimated Exceution Plan Ctrl+L ,Show exection Plan Ctrl+K,

set SHOWPLAN_TEXT on
go
select * from stock_detail inner join barcode_master on stock_detail.barcode=barcode_master.barcode
where style1 in(1,3)

select * from stock_detail inner join barcode_master on stock_detail.barcode=barcode_master.barcode
where
exists (select style_code from style1 where style_code in(1,3) and barcode_master.style1=style1.style_code )
go

set FORCEPLAN on
select * from stock_detail inner join barcode_master on stock_detail.barcode=barcode_master.barcode
where style1 in(1,3)

转载于:https://www.cnblogs.com/antony1029/archive/2006/11/21/567021.html