Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does it make sense to change this SP?
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01325771
Message ID:
01325780
Views:
12
>>>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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform