SQL server converts the IP address saved in integer to the normal IP format of dot Division

From , 4 Years ago, written in SQL, viewed 51 times.

SELECT dbo.IPADDRESS.IPADDRESS,
CAST(ROUND( (CAST(CAST(dbo.IPADDRESS.IPADDRESS AS BINARY(4)) AS BIGINT) / 16777216 ), 0, 1) AS VARCHAR(4)) + '.' +
CAST((ROUND( (CAST(CAST(dbo.IPADDRESS.IPADDRESS AS BINARY(4)) AS BIGINT) / 65536 ), 0, 1) % 256) AS VARCHAR(4)) + '.' +
CAST((ROUND( (CAST(CAST(dbo.IPADDRESS.IPADDRESS AS BINARY(4)) AS BIGINT) / 256 ), 0, 1) % 256) AS VARCHAR(4)) + '.' + 
CAST((CAST(CAST(dbo.IPADDRESS.IPADDRESS AS BINARY(4)) AS BIGINT) % 256 ) AS VARCHAR(4)) AS IPDottedNotation
//SQL/8735

Reply to "SQL server converts the IP address saved in integer to the normal IP format of dot Division"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?

Spam protection Type in the letters

https://burned.cc - Burn After Reading Website

Pastebin.vip

SQL server converts the IP address saved in integer to the normal IP format of dot Division

Reply to "SQL server converts the IP address saved in integer to the normal IP format of dot Division"