数据库设计报告与ppt 超市物流管理 查询销售记录的存储过程 CREATE PROCEDURE [dbo].search_sell_rec @id varchar(8), @name varchar(30), @time varchar(30), @mid varchar(8) AS IF (@mid = '') BEGIN SELECT P.p_id AS pid, P.p_name AS pname , P.p_scale AS pscale , S.s_qty AS sqty , S.s_price AS sprice , S.s_time AS stime ,