摘要： create proc P_DataClear(@clearTime datetime --清理的时间)as--查询出需要删除的数据订单号declare @outOrderNB table(CustomerOrderNo varchar(12));insert into @outOrderNB select dbo.tbl_POD.CustomerOrderNo from dbo.tbl_PODwhere dbo.tbl_POD.WaybillState='9' and convert(nvarchar(7), actualcompleteTime,120) = convert 阅读全文