SQL Tutorial: Easily Update Rows Based on Complex Joins
There are a lot of times I’d like to update hundreds of rows in a database based on a complex set of conditions. In doing a traditional update SQL statement there is no way...
Category: Tutorials
MySQL FIX: connect to server at ‘localhost’ failed error: ‘Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
In short the error means that mysql isn’t running. So the next reason is, why? Recently I upgraded from php4 to php5 on one of my servers. Ever since then any time mysql does...
MSSQL Tutorial: Search code inside of stored proceedures
DECLARE @SEARCHSTRING VARCHAR(255), @notcontain Varchar(255) SELECT @SEARCHSTRING = ‘expiration_date =’, @notcontain = ” SELECT DISTINCT sysobjects.name AS [Object Name] , case when sysobjects.xtype = ‘P’ then ‘Stored Proc’ when sysobjects.xtype = ‘TF’ then ‘Function’...
Error FIX: Crystal Report Won’t Stop Loading
Problem: I noticed if you have really large strings in the crystal report, instead of having them as type text (aka memo in Crystal) the report won’t ever stop loading. For instance, a field...
MSSQL Tutorial: Select All Tables & Fields
select table_name, column_name, data_type, character_maximum_length, is_nullable from information_schema.columns where table_name in (select name from sysobjects where xtype=’U’) order by table_name
SQL Server 2005, Select All Tables & Fields
SQL: select table_name, column_name, data_type, character_maximum_length, is_nullable from information_schema.columns where table_name in (select name from sysobjects where xtype=’U’) order by table_name
IE FIX: Remove Gray Box From Transparent .png Files
This should only be used when the browser is IE 5.5 or earlier. Download this library to automatically fix all your img tags for you (bottom of page): source
Web Design FIX: Opera & Safari Links Always Red
So this is probably the stupidest thing ever. If you’re importing files into your page and for some reason one of those files doesn’t exist, Opera/Safari generate a 404 page not found error. This...
