我就想这样 select * from a select * from b select * from cselect * from D 有没有办法在SQL里面控制下,使得这些语句都执行,但最后的结果是返回的select * from D 的结果
刚看了个列子说是这样 CREATE PROCEDURE lyg_getArticleClass as set nocount on select * from tba select * from tbb select * from tbc set nocount off select * from tbd go 发现不行呀
union
select * from b
datatable[0],datatable[1]
这样是步是影响速度呀!
select * from a
select * from b
select * from cselect * from D
有没有办法在SQL里面控制下,使得这些语句都执行,但最后的结果是返回的select * from D
的结果
CREATE PROCEDURE lyg_getArticleClass
as
set nocount on
select * from tba
select * from tbb
select * from tbc
set nocount off
select * from tbd
go
发现不行呀