>Compared to that, adjusting to C# or VB syntax is not much of a issue.

Once the Framework is understood, converting from one language to another is a matter of a...

If VB.NET has OPTION STRICT set ON, then the code produced is equally as efficient as C#!

There is are plenty of C# programmers who decry VB.NET whereas the reverse is...

I agree that aggregate functions make little sense for IP Addresses.

This is a very important discussion for developers such as myself as originating IP addresses need to be logged...

Thankyou (Ladies and) Gentlemen

for this ongoing discussion. Recent items have shown me the need to make further comparions on what is the best way to store an...

>Now I'm going to test the retrieval of the varbinary(4) back to a string.. When I'm all done I will attach the code for all.

Have you done this?

Thank you.

It would be very interesting to benchmark the CLR solution v the TSQL solution.

Both the original article and this thread have been very useful. I now need to reconsider my designs for web databases where audit logging of the apparent IP address...

>I've always liked storing IP's as binary(4) - still 4 bytes, but simpler conversions:

Under what licence (if any) are you releasing your code?

May it be included in a project relese...

Thank you. I will just document that the ALTER permission is required.

>If you're returning rows of data, just use a result set. But if you're returning a single row with only a few columns, output parameters are faster. It requires less...

Please have a look at:

http://msdn.microsoft.com/en-us/library/ms143505%28SQL.90%29.aspx

http://msdn.microsoft.com/en-us/library/ms143412.aspx

I also have this problem. I have increased the size of the decimal column C to 38, 14 - maximum size and an excessive amount of precision.

If I do a