Dynamic Query Or Non Dynamic Query

Hi

I have two options two write queries one Static & one Dynamic.
I wanted to know which one will be good.

Example

if @x = 1
Select * From Customers order by CustomerID
Else IF @x = 2
Select * From Customers Order by CustomerName
Else IF @X = 3
Select * From Customers Order by city
else..
...


Against this
Set @Strsql = "Select * From Customers order by " + @Orderby
Exec (@Strsql)

Which will have better performance ?
Is SQL Stores query plans for static queries with all if statements clause
or it remains as good as dynamic ?

Thanks,
Manoj