The Command Prompt is the classic command-line interface for Windows. While it’s limited to basic commands compared to the modern modern PowerShell, many of the best-known commands work in it.
SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...