sqlserver中order by 问题？

[dandanfst]

我想在order by 后加多个条件，
在Access中order by 可以这样使用
sql="select * from pro order by istop=1,pro_date desc"
在sqlserver中，我该如何使用呢？

[fwacky]

select  * from pro where istop=1  order by  pro_date desc

[华夏小卒]

order by col1,col2 desc

[liangCK]

order by case hwen istop=1 then 0 else 1 end,pro_date desc

[dandanfst]

该怎么称呼楼上的前辈呢？可以讲详细点吗？