If @searchBy ='s_number' --// ?看看能否简化
Select Students.department From Students
Where Students.s_number = @searchValue
If @searchBy ='studentName'
Select Students.department From Students
Where Students.studentName = @searchValue
能否只是根据这两段进行判断一下:
Students.s_number = @searchValue
Students.studentName = @searchValue把这段代码,用作一段共享
Select Students.department From Students
Where
Select Students.department From Students
Where Students.s_number = @searchValue
If @searchBy ='studentName'
Select Students.department From Students
Where Students.studentName = @searchValue
能否只是根据这两段进行判断一下:
Students.s_number = @searchValue
Students.studentName = @searchValue把这段代码,用作一段共享
Select Students.department From Students
Where
From Students
Where (CASE @searchValue WHEN 's_number' THEN studentName ELSE department END )=@searchValue