Transact SQL will produce the same results from a command-line prompt that it will in the GUI environment.