Run SQL Queries via the Command Line
Filed under: Compatibility, Endpoint Management and Virtualization
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....