如何使用过程在SQL中写入条件 [英] How to writ If condition in SQL using procedure

问题描述

你好

有任何人写一个小的SQL查询

我写下面的程序，这里是拖车领域[校长]，[性别]
，其值为'1'或值'2'



现在我想在此字段中选择IF条件，如下所示



如果Teachers_TB.HeadMaster_Teacher值= 1，选择'Teacher'这个名字必须显示



如果Teachers_TB.HeadMaster_Teacher值= 2选择'HeadMaster'这个名字必须显示



另外

如果Teachers_TB.Gender值= 1选择'男'这个名字必须显示



如果Teachers_TB.Gender值= 2选择'女'这个名字必须显示

谢谢



我的程序：

Hello
There are any one to writ a small SQL query
I writ the below procedure, Here are tow field [Headmaster],[Gender]
which the have value '1' or value '2'

Now I want select a IF condition on this field like below

If Teachers_TB.HeadMaster_Teacher value=1 select 'Teacher' this name must be display

If Teachers_TB.HeadMaster_Teacher value=2 select 'HeadMaster' this name must display

Also
IF Teachers_TB.Gender value=1 select 'Male' this name must be display

If Teachers_TB.Gender value=2 Select 'Female' this name must be display
Thanks

my procedure:

ALTER proc [dbo].[ExportDatatoExcel]
as
begin

select PName_en,DName_en,SName,Code,Type,Grade,School.Gender,

Enrolled_Male,Enrolled_Female,Passed_Male,Passed_Female,
Failed_Male,Failed_Female,PermanentAbsent_Male,PermanentAbsent_Female,
DropOut_Male,DropOut_Female,

HeadMaster_Teachers,Teachers_TB.Gender,Phd,Master,Bachelors,TED15,TED14,TED12,
Vocational14,Vocational12,RelegiousMadrasa14,RelegiousMadrasa12,Sport14,Sport12,
General12,LowerSecondary,Primaryt,Private,
TeachersTashkeel,Male,Female

from School
join Province on School.ProvinceID=Province.P_ID
join District on School.DistrictID=District.D_ID
INNER JOIN Students ON School.S_ID = Students.Student_ID
join Teachers_TB on Teachers_TB.Teacher_ID=School.S_ID
join Tashkeel on Tashkeel.TashkeelID=School.S_ID
Order by P_ID,D_ID

end

推荐答案

用户案例x然后我的结束作为myfield

User CASE x THEN y ELSE z END as myfield

select 
    column1,
    column2,
    CASE Teachers_TB.HeadMaster_Teacher 
      WHEN 1 THEN 'Teacher'
      WHEN 2 THEN 'HeadMaster'
    END AS column3Name,
    CASE Teachers_TB.Gender
      WHEN 1 THEN 'Male'
      WHEN 2 THEN 'Female'
    END AS column4Name,
from
....

我解决了这个问题

所有代码工作正常任何人都可以使用此代码自我

来自阿富汗国家的Hedayatullah Hoshmand

I solution this problem
All Code Work right any one can use from this code for self
Hedayatullah Hoshmand from Afghanistan country

ALTER proc [dbo].[ExportDatatoExcel]
as
begin
select PName_en as Province,DName_en as District,SName as [School Name],Code,Type,Grade,School.Gender, 

Enrolled_Male,Enrolled_Female,Passed_Male,Passed_Female,
Failed_Male,Failed_Female,PermanentAbsent_Male,PermanentAbsent_Female,
DropOut_Male,DropOut_Female,
CASE HeadMaster_Teachers
	WHEN 1 THEN 'Teacher'
    WHEN 2 THEN 'HeadMaster'
	END AS [HeadMastere & Teachers],
    CASE Teachers_TB.Gender
      WHEN 1 THEN 'Male'
      WHEN 2 THEN 'Female'
	  END AS Gender,
Phd,Master,Bachelors,TED15,TED14,TED12,
Vocational14,Vocational12,RelegiousMadrasa14,RelegiousMadrasa12,Sport14,Sport12,
General12,LowerSecondary,Primaryt,Private,
TeachersTashkeel,Male,Female

from School
join Province on School.ProvinceID=Province.P_ID 
join District on School.DistrictID=District.D_ID 
INNER JOIN Students ON School.S_ID = Students.Student_ID
join Teachers_TB on Teachers_TB.Teacher_ID=School.S_ID
join Tashkeel on Tashkeel.TashkeelID=School.S_ID
 

Order by P_ID,D_ID


end

这篇关于如何使用过程在SQL中写入条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！