SQL Server equivalent to Oracle’s NULLS FIRST?

You can do some trick:

ORDER BY (CASE WHEN [Order] IS NULL THEN 0 ELSE 1 END), [Order]