The two will produce the same execution plan – either a table scan, index scan, or index seek, depending on if/how you have your table indexed.
You can see for yourself – Displaying Graphical Execution Plans (SQL Server Management Studio) – See the section called “Using the Execution Plan Options”.