Posted by Neil on 11/01/05 04:39

You're saying that SQL 2000 performs implicit conversions, but SQL 7
doesn't? That seems like a step backwards for MS. I wish Access didn't
perform implicit conversions.


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns97011305379Yazorman@127.0.0.1...
> Neil (nospam@nospam.net) writes:
>> After I got your note I did go ahead and make MachName nchar, as BOL
>> says that HOST_NAME() returns that type, and the sample it showed of
>> storing its return value in a table used an nchar(30) field.
>>
>> The InvtrySelections table had the PK (ID/MachName) as the clustered
>> index. I created a second index on MachName alone, and it made it the
>> clustered index.
>>
>> With the above two changes, the results were the same. Still getting
>> "#Deleted".
>
> As I said, I did not really expect that. I more had performance in mind.
>
> But now it occurred to me, that it's a bit of a non-issue for you. To
> wit, the rules for implicit conversion are different in SQL 7 and
> SQL 2000. The potential performance problem I saw, probably only exists
> in SQL 2000. Then again, it's good to be prepared, in case you upgrade
> to SQL 2005 one day. :-)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>

[Back to original message]