Posts Under MSSQL Category
LEN in MySQL
In MySQL 5.1 LEN is called LENGTH, you use it exactly the same and pass in the link, so: LENGTH(link).
SELECT Duplicate Items Using SQL
If you have a table which has duplicate items in then you can use the below statement to select them. SELECT * FROM tableName GROUP BY columnName HAVING ( COUNT( columnName) >1 )
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 following: SELECT [columnNameHere] FROM [databaseNameHere].[dbo].[databaseTableNameHere] WHERE [columnNameHere] IS NOT NULL
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 either one of two things, and those are: Overloaded Server is “Just Plain Shit” The…
