sqlserver中order by 问题？

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

---

SQL code:

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

---

SQL code:

order by col1,col2 desc

---

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

---

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