In MySQL 5.1 LEN is called LENGTH, you use it exactly the same and pass in the link, so: LENGTH(link).
MSSQL Select Not Null
I mainly use MySQL these days, so get screwed over for a few minutes when I have to do something in MSSQL that is slightly different when it comes to it’s custom syntax. If you want to show all entries in a specific column and where it is not Null then you can do the
Read More…
ODBC SQL Server Memory General Network Error
Microsoft OLE DB Provider for ODBC Drivers error ’80004005′ [Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation. /site/path/to/script/aspfile.asp, line # ..and that’s what it throws you! At about this point you may want to scream, or just be a tad annoyed by that damn machine running your site. Basically your server is
Read More…
Why we don't choose MSSQL!
Everybody always raves how great Microsoft SQL Server is, and how much data it can hold, and how much bigger it’s “package” is than your own. But the truth is that I hate it with a passion! I use RDBMS‘ on a daily basis and never used to hate MSSQL so much until recently when
Read More…