?? proc_deliv_dup_check.sql
字號:
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -