Post reply

T-SQL to compress (shorten) IPv6 address

  • September 12, 2018 at 11:35 am

    #377296

    Comments posted to this topic are about the item T-SQL to compress (shorten) IPv6 address

  • May 14, 2019 at 8:36 am

    #3641794

    what about this ipv6 ('0000:0000:0000:b120:0000:ffff:c6a1:1938')

    it gives me result like

    ::b120:0:ffff:c6a1:1938

  • May 14, 2019 at 10:03 am

    #3641809

    What your your reasons for choosing to use a WHILE loop here, and a multi-line scalar function? Inline Table-value functions are extremely powerful, and quick (as in inline scalar functions in SQL Server 2019).

    As for the WHILE, why not use a set-based method?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply