Main Resume Academic Information Current Projects Friends that have World Wide Web Pages Interesting Links Mathematical Problems Fun Pages Tech Pages

 

Information I found useful

SQL show me all tables that have data in them

DECLARE    
    @table_name     SYSNAME,
    @table_id       INT,
    @column_name    SYSNAME,
    @sql_string     VARCHAR(2000)

DECLARE tables_cur CURSOR FOR SELECT name, object_id FROM sys.objects WHERE type = 'U'

OPEN tables_cur

FETCH NEXT FROM tables_cur INTO @table_name, @table_id

WHILE (@@FETCH_STATUS = 0)
BEGIN
	SET @sql_string = 'declare @tablecount int select @tablecount = count(*) from ' + @table_name + ' if (@tablecount > 0) PRINT ''' + @table_name + ' -- '' + cast(@tablecount as varchar(10))'
	
	EXECUTE(@sql_string)

    FETCH NEXT FROM tables_cur INTO @table_name, @table_id
END

CLOSE tables_cur

DEALLOCATE tables_cur

Linear Equation Solver

I wrote a program in Java which will calculate the solution to a bunch of linear equations.

Main Resume Academic Information Current Projects Friends that have World Wide Web Pages Interesting Links Mathematical Problems Fun Pages Tech Pages