proc_deliv_day_chk.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 13 行

if object_id('dbo.Proc_Deliv_Day_Chk') is not null
drop Procedure dbo.Proc_Deliv_Day_Chk
go

Create Procedure Proc_Deliv_Day_Chk
@deliv_dt datetime = null
as
begin
	select FYear from Plant_Calendar where FYear = datepart(YY,@deliv_dt)
	and Fmonth = datepart(mm,@deliv_dt)  and Fday = datepart(dd,@deliv_dt) and holiday_flag = 1
	
end
go