By: Spencer Woodruff “Japan is fighting the rebels with no success. They have asked help from many countries but they have declined. Everyone is evacuating Tokyo after the attack of Kyoto. Boats have been transporting people to…” Click. As I walked in my mom turned the TV off. “Edwin, we need to leave” said my [...]

Read More

After asking around and getting a few suggestions on how to do an automated search for SQL Server tables that have columns that look like foreign keys but do not have constraints on the columns. Here is the SQL statement for this search: SELECT sys.tables.name AS TableName, sys.columns.name AS ColumnName from sys.columns, sys.tables where sys.columns.object_id [...]

Read More