关于存储过程中的验证 [英] Regarding validations in stored procedure

问题描述

大家好，



1.我有输入参数，如@ age，@ date，@ time和@gender，输出参数是@paid amt。

2.星期一到星期五（截至晚上9点）我的条件是

a）医生咨询费用就像

10年以上 - 200 rs

5-10岁之间 - 100 rs

低于5年 - 0 rs

b）周六医生咨询费是喜欢

0-10岁之间 - 300 rs

10年以上 - 500 rs

c）周日医生咨询费就像

介于0-10岁之间 - 300美元

10年以上 - 700美元

d）晚上咨询费用就像

0-10岁之间 - 200 rs

10年以上 - 500 rs





所以我想在storedprocedure中编写验证以满足上述条件s。



请帮我完成这项任务。



先谢谢，

Avinash P



SHOUTING删除 - OriginalGriff [/ edit]

Hi all,

1.I have input parameters like @age,@date, @time And @gender and output parameter was @paid amt.
2. I have a conditions like
a)between monday to friday(upto 9 pm) the doctor consultation fee was like
Above 10 years -- 200 rs
between 5-10 years -- 100 r.s
below 5 years-- 0 r.s
b) On saturdays the doctor consultation fee was like
between 0-10 years -- 300 r.s
above 10 years-- 500 r.s
c) On sundays the doctor consultation fee was like
between 0-10 years -- 300 r.s
above 10 years-- 700 r.s
d) on nights the consultation fee was like
between 0-10 years -- 200 r.s
above 10 years-- 500 r.s


so i want to write validation in a storedprocedure to met the above conditions.

please help me out from this task.

Thanks in Advance,
Avinash P

[edit]SHOUTING removed - OriginalGriff[/edit]

推荐答案

我们不做你的功课：这是有原因的。它就是为了让你思考你被告知的事情，并试着理解它。它也在那里，以便您的导师可以识别您身体虚弱的区域，并将更多的注意力集中在补救措施上。



亲自尝试，你可能会发现它不是和你想的一样困难！

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

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