【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,GetOrderNum.sql,希望对大家有所帮助!
use BuyGoods
go
if object_id('dbo.GetOrderNum') is not null
drop procedure dbo.GetOrderNum
go
create procedure GetOrderNum
@CustomerName varchar(40)=null
as
begin
select 总合计=sum(合计) from CustomerOrder where 客户名称=@CustomerName
return
end
go