Share the Love! Free Programming eBooks
GoalKicker.com is giving away these free programming books and I thought I would share the love for anyone who hasn’t seen them yet. There are more available from their website but these are the...
Tagged: sql
MySQL Tutorial: Archiving and Loading Archived Table Data
Let’s say you have a really large table and you want to archive the data to a new table so that your main table is smaller again. This is useful with things like chat...
MSSQL Tutorial: Delete All But 1 Duplicate Records
declare @id int, @total int /* SELECT COUNT OF POTENTIAL DUPLICATES */ select id, count(id) from [tablename] where [parameters] group by [column name] /* LOOP TO CLEAN UP THE DUPLICATES */ declare aff_crsr cursor...
SQL Tutorial: Select, Update & Delete Syntax
Select Statements General Syntax SELECT [column], [column], [column] FROM [tablename] WHERE [column] = [value] Select All Columns SELECT * FROM [tablename] Limit # of Records Returned – MSSQL SELECT TOP [number] * FROM [tablename]...
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...
Ten Reasons Not To Use ASP!
10. I have to write my own isNull function? 9. No double equals = retarded language 8. You can’t response.write across multiple lines unless you _ & fix them. Can’t concatenate across multiple lines...
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
CHM & PDF Programming Manuals
I know these have come in handy for me over the years. Right click and save link as. AJAX – chm Pragmatic AJAX – pdf Allegro 4.2.1 – chm C++ Addison Reference – chm...
