Why do these two behave differently? I don't know, but T-SQL is providing you the two ways you can use as needed. In the case where you want all the...