SQL Query of the Day #301220131625

Query:

SELECT name FROM Deep13.sys.tables WHERE name like '%Forrester%'

Function: Find all the tables in the database Deep13 with the string Forrester in the name.

Source: Me. This is helpful if you’re looking around a database with hundreds/thousands of tables for a clue about where relevant data might be.

Comments: I need a neologism for the phenomenon where you start entering your password at a blank Windows terminal, and by the time the screen emerges from hibernate mode, you realize you forgot to enter your login and have just been typing your password in the Windows “User name” field for everyone in the office to see. And then you realize you’re back in 8th-grade geometry class with no pants on ….

Comments Off on SQL Query of the Day #301220131625

Filed under Uncategorized

Comments are closed.