Run SQL Queries via the Command Line

Although I tend to stick with GUI's, the following two utilites that come with SQL Server allow you access to MSDE, Express as well as the Server via the command line:

MSDE/SQL 2000 - OSQL: http://msdn2.microsoft.com/en-US/library/aa214012(SQL.80).aspx

Express/SQL 2005 - SQLCMD: http://msdn2.microsoft.com/en-us/library/ms162773....