存储过程执行问题？ [英] stored procedure execution problem?

问题描述

ALTER PROCEDURE [dbo].[K_FS_GetDynamicdatatoTable] --'2014031711','1/15/2014 12:00:00 AM'
@orderno varchar(50),
@date datetime	
AS
BEGIN
	
	SET NOCOUNT ON;
	select FT.feedtype,BG.bagtype,OD1.noofbags,round(MR.rateperkg,3)as rateperkg
from K_FS_OrderDetails OD
inner join K_FS_OrderDetails1 OD1 on OD.sno=OD1.ID
inner join K_FS_bagtype BG on BG.sno=OD1.bagtype
inner join K_FS_FeedMrpDetails MR on MR.feedtype=OD1.feedtype
inner join k_FPS_FeedType FT on FT.sno=MR.feedtype and FT.sno=OD1.feedtype
where OD.orderno=@orderno and MR.date=@date

END

在我的程序中，没有条件成功，如果我通过OD.Orderno然后不是问题..但如果我提到MR.date然后没有找到数据......在这我错了吗？

这里



从K_FS_FeedMrpDetails中选择*，其中date ='2013-12-16 00：00：000'





'日期'数据也可以在我的程序中使用，但是找不到数据...请帮帮我？

in my procedure,without where condition excetion successfully,and if i pass OD.Orderno then not a problem..But if i mention MR.date then No data found...In this what i mistake ?
Here

select * from K_FS_FeedMrpDetails where date = '2013-12-16 00:00:000'


'date' data also availble in my procedure,but data is not found...please help me?

推荐答案

您好，



检查数据库中存在的确切日期。如果时间不是事实，那么你可以像这样修改商店程序

Hello ,

Check what is the exact date exists in your database . If time is not a fact , then you can modify the store procedure like this way

ALTER PROCEDURE [dbo].[K_FS_GetDynamicdatatoTable] --'2014031711','1/15/2014 12:00:00 AM'
@orderno varchar(50),
@date datetime	
AS
BEGIN
	
	SET NOCOUNT ON;
	select FT.feedtype,BG.bagtype,OD1.noofbags,round(MR.rateperkg,3)as rateperkg
from K_FS_OrderDetails OD
inner join K_FS_OrderDetails1 OD1 on OD.sno=OD1.ID
inner join K_FS_bagtype BG on BG.sno=OD1.bagtype
inner join K_FS_FeedMrpDetails MR on MR.feedtype=OD1.feedtype
inner join k_FPS_FeedType FT on FT.sno=MR.feedtype and FT.sno=OD1.feedtype
where OD.orderno=@orderno and
 MR.date=CAST(CONVERT(CHAR(10),@date,102) AS DATE)---check the only datepart of the given date
 
END

谢谢

animesh

thanks
animesh

这篇关于存储过程执行问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！