create procedure pro_T as select 统计产量=( SELECT COUNT(*) FROM dbo.EMS_Pallet WHERE TraceDateTime LIKE replace(CONVERT(varchar(8),getdate(),23),'-','')+'%' AND WO_Type <>'PP15' )+( SELECT COUNT(*) FROM dbo.EMS_Pallet_Interim WHERE TraceDateTime LIKE replace(CONVERT(varchar(8),getdate(),23),'-','')+'%' AND WO_Type <>'PP15' )
create procedure pro_T
as
select
统计产量=(
SELECT COUNT(*)
FROM dbo.EMS_Pallet
WHERE TraceDateTime LIKE replace(CONVERT(varchar(8),getdate(),23),'-','')+'%' AND WO_Type <>'PP15'
)+(
SELECT COUNT(*)
FROM dbo.EMS_Pallet_Interim
WHERE TraceDateTime LIKE replace(CONVERT(varchar(8),getdate(),23),'-','')+'%' AND WO_Type <>'PP15'
)
你的存储过程也很简单的,自己找个sql server基础书简单看看就可以了,也可以到网上找个小例子看看。