SqlServer中如何按姓氏笔画排序

Select *
From TableName
Order By CustomerName
Collate Chinese_PRC_Stroke_ci_as