Convert int IP-address to dot-notation

integer IP-address converted to varchar dot-notationUsage SELECT dbo.IPNumberToString(-2037012288)

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-10-20 (first published: 2004-07-29)

465 reads

Setting permissions (fix for no dbo users)

fix script from tcartwright@thesystemshop.com (http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=600) for no dbo users

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-12-02

180 reads

As for me, I'll keep writing whenever time permits. I don't expect every post...

This is an interesting invitation this month. Jeff Ianucci is a new host, and...

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Comments posted to this topic are about the item Pay for Performance, which is...

Hi I have this slow query that is pulling data from a linked server....

Comments posted to this topic are about the item Too Many Choices

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;