Skip to main content

MC Moe

Search This Blog

Perfect Diagram on SQL Joins

January 17, 2014

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

source: http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

diagram explain inner join left outer perfect right source sql venn

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

Rapid Tables - looking for that color or ASCII code?

http://www.rapidtables.com/ very useful: ASCII table, big/little endian, color/rgb tables + more engineering resources. I came across this website when i needed the hex codes of various rgb colors i was using in Java. In it's about section it says : RapidTables.com contains quick reference information and tools.

INVEST in Good Stories and SMART Tasks

Below are some XP tips for the Agile world... The INVEST and SMART acronyms can remind teams of the good characteristics of stories and tasks. User stories are requirements, consider them composed of the triple C : C ards (their physical medium) C onversation (the discussion surrounding them) C onfirmation (tests that verify them). User stories act as a pidgin language , customers/users/programmers use it so that all sides can agree enough to work together effectively. A good story is an INVEST story: I ndependent They don't overlap in concept, and can be implemented in any order. Can't always achieve this; ex: "3 points for the first report, then 1 point for each of the others." N egotiable Is not an explicit contract for features; rather, details will be co-created by the customer and programmer during development. It captures the essence, not the details. Over time, the card may acquire notes, test ideas, and so on, b

Ruby pro tips from Rails core committer Aaron Patterson WHERE IS THAT METHOD? Q: This code is calling a method, but I don't know where the method is defined. How can I find it? A: Use the method method. The method method will return a method object and let you call source_location to find the method location. For example: p object.method(:unknown_method).source_location If object has the instance method unknown_method , this code will print the location of that method. WHO IS CALLING ME? Q: I'm inside a method, but I don't know who called this method. How can I find out? A: Use the caller method. The caller method will give you the current stack trace, so you can do p caller and see who is calling you. Alternatively, just raise an exception, and you'll see the backtrace. WHAT IS MY CLASS? Q: I'm editing a method, but I'm not sure what class it's defined on. How can I find out? A: Use the class method. For example

Powered by Blogger