Convert int IP-address to dot-notation
integer IP-address converted to varchar dot-notationUsage SELECT dbo.IPNumberToString(-2037012288)
2004-10-20 (first published: 2004-07-29)
321 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
2002-12-02
127 reads
Blogs
Daily Coping 28 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
The DBA as a helpdesk.
Every one and again you will see people asking What skill do you think...
What’s my MAC Address in a Command Prompt?–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
what this constrain meaning ?
I work on sql server 2012 i see constrain but i don't know what...
OK, I still think like a programmer -- is there a better way to do this?
My SQL tools tell me this invokes an inefficient step with an index scan. ...
Update table FirstName & LastName from Email addresses
I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field...
Ask SSC