>>>>re: 1. If the ID doesn't exist you will get an empty table. I'd worry about it at the client end.
>>>>
>>>>re: 2. Unless your table record is extraordinarily large, pulling * makes maintenance easier assuming ID is a primary or unique key.
>>>
>>>It is very wide table.
>>
>>What is the biggest record size?
>
>I'm not here at the moment and lots of fields are varchar(). But there are ~100+ fields.

No I ask for bytes :-)
But because SQL Server has limit to 8060 bytes (if no text, image, varchar(max) or varbinary(max) fields are involved) so I think you have 8K bytes to transfer. No matter how slow is the connection 8K will be transferred in a no time. Maybe you could use SELECT * ... (as William suggested) and then in your FrontEnd you decide which fields you should show to the user?