Paw Prints

Friday, November 14, 2014

SQL Poetry Friday #3

Hey, poetry lovers! This was a fun little ditty that I created out of Pinal Dave's search for column names in a particular database by table.  I'll post the code and my own results from my master database.

SELECT
c.name AS 'When I Am'
FROM sys.tables t
INNER JOIN sys.columns c 
ON t.OBJECT_ID = c.OBJECTID
WHERE c.name LIKE 'l%'

Results:


If your mind makes the leap like mine did reading quickly down the column, I read it as "When I am low, I start; last run."  Try for yourself and see how your database is feeling.

Woof, woof!
Jason

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.