Search code examples
sql-serversql-server-2000sqlcmd

Is there any way to run the SQL queries on SQL Server 2000 using Command Prompt


Is there any way to run the SQL queries on SQL Server 2000 using command prompt. I just done a google search and understood that there is a command called SQLCMD, but this is only applicable to SQL Server 2005 +.


Solution

  • For SQL Server 2000, the tool was called osql.

    See the official TechNet docs on how to use it