selectFirstName,TitleOfCourtesy,CourtesyInTC=
CaseTitleOfCourtesy
WhenMs.Then水女人
WhenDr.Then博士博
WhenMr.Then先仔
WhenMrs.Then密斯
Else师长教师/蜜斯
End
Fromemployees
B分列
懂得了基础Z法後咱就能够_始W按怎使用OrderBy加上Case⑹碜B的Y料分列
Declare@OrderKeyTinyInt
Set@OrderKey=2
SelectCompanyName,ContactName,ContactTitle
FromCustomers
OrderByCase
When@OrderKey=1ThenCompanyName
When@OrderKey=2ThenContactName
ElseContactTitle
End
不^@H像不太用,最少在ASP中,以是接下碓碜鲆AΤ绦
CreateProceduresp_SelectCustomersDynamicOrder
@OrderKey=Null
As
SelectCompanyName,ContactName,ContactTitle
FromCustomers
OrderByCase
When@OrderKey=1ThenCompanyName
When@OrderKey=2ThenContactName
ElseContactTitle
End