Command prompt utilities, some resources in one place.


Sometimes there is some confusion on the different Command Prompt utilities.


 


I will not go into detail on this, rather providing a collection of the online resources.


 


The short summary is this:


-          ISQL is no longer supported, use SQLCMD


-          ISQL uses DB-LIB (6.5 client level), some SQL 2000 features are not supported, doesn’t support UNICODE input files


-          OSQL uses ODBC, supports UNICODE input files


-          ISQLW is SQL Query Analyzer


-          SQLCMD uses OLE DB


-          SQLNCLI (SNAC / SQL Native Client) combines the OleDb and ODBC provider and has added functionality such as MARS and UDT


 


References for the above:


 


Command Prompt Utilities (SQL Server 2000) -> isql Utility


http://msdn.microsoft.com/en-us/library/aa214007(SQL.80).aspx


Command Prompt Utilities (SQL Server 2000) -> osql Utility


http://msdn.microsoft.com/en-us/library/aa214012.aspx


Command Prompt Utilities (SQL Server 2000) -> isqlw Utility


http://msdn.microsoft.com/en-us/library/aa214005(SQL.80).aspx


 


SQL Server 2005 Books Online (September 2007) -> sqlcmd Utility


http://msdn.microsoft.com/en-us/library/ms162773(SQL.90).aspx


SQL Server 2005 Books Online (September 2007) -> SQL Native Client Programming


http://msdn.microsoft.com/en-us/library/ms130892(SQL.90).aspx


 


SQL Server 2005 Books Online (September 2007) -> Discontinued Database Engine Functionality in SQL Server 2005


http://msdn.microsoft.com/en-us/library/ms144262(SQL.90).aspx          


SQL Server 2008 Books Online (August 2008) -> Discontinued Database Engine Functionality in SQL Server 2008


http://msdn.microsoft.com/en-us/library/ms144262.aspx


 


For protocol specific information, I can recommend the SQL Protocols blog:


http://blogs.msdn.com/sql_protocols/

Comments (0)

Skip to main content