Tagged: sql


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]...


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...