如何使用IF..Else语句创建过程。 [英] How do I create Procedure with IF..Else statement.

问题描述

我是新的在SQL服务器PLZ告诉我如何找到ans。用于创建程序使用IF ..Else案例以获得准确的输出。



EID EName ESalary Grade

1- A - 1000 - A

1- B - 1000- B

3- C - 3000 - C



写入产品的显示等级根据工资



根据工资显示员工姓名的工资

Hi, I m New In Sql server plz tell me how to find the ans. for Create Procedure using IF..Else case for accurate Output.

EID EName ESalary Grade
1- A - 1000 - A
1- B - 1000- B
3- C - 3000 - C

Write Procudure for show Grade of as per salary

Write Procudure for show employee name as per salary

推荐答案

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



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

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!

这篇关于如何使用IF..Else语句创建过程。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！