proc_deliv_dup_check.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

if object_id('dbo.Proc_Deliv_Dup_Check') is not null
drop procedure Proc_Deliv_Dup_Check
go

create procedure Proc_Deliv_Dup_Check
@pono varchar(15) =null,
@item int = null,
@deli_day datetime = null
as
begin
		

	select item
			from ord_item where pono =@pono and item =@item and
	    		(convert(char(4),datepart(yy, deli_day))
           		  +'/'+convert(char(2),datepart(mm, deli_day))
           		 +'/'+convert(char(2),datepart(dd, deli_day))) 
	
            		  =(convert(char(4),datepart(yy,@deli_day))
             		   +'/'+convert(char(2),datepart(mm,@deli_day))
               			 +'/'+convert(char(2),datepart(dd,@deli_day)))
	  		
end