Difference between isql.exe and osql.exe while executing sql script
来源:互联网 发布:mac可设置定时关机吗? 编辑:程序博客网 时间:2024/06/02 07:52
isql does not support connecting to a named instance of SQL Server 2000. If no server is specified, isql connects to the default instance of SQL Server on the local computer. This option is required if you are executing isql from a remote computer.
All DB-Library applications, such as isql, work as SQL Server 6.5–level clients when connected to SQL Server 2000. They do not support some SQL Server 2000 features. The osql utility is based on ODBC and does support all SQL Server 2000 features. Use osql to run scripts that isql cannot run. For more information about the restrictions on SQL Server 6.5–level clients, see Connecting Early Version Clients to SQL Server 2000 in SQL Server Books Online.
The SQL Query Analyzer default is to save SQL scripts as Unicode files. The isql utility does not support Unicode input files. Attempting to specify one of these files in the -i switch results in a 170 error:
Incorrect syntax near ' '.
Use the osql utility to run these Unicode files. An alternative is to specify ANSI instead of Unicode in the File format list of the SQL Query Analyzer File/Save As dialog box.
Like most DB-Library applications, the isql utility does not set any connection options by default. Users must issue SET statements interactively or in their scripts if they want to use specific connection option settings.
The isql utility is started directly from the operating system with the case-sensitive options listed here. After starting, isql accepts Transact-SQL statements and sends them to SQL Server 2000 interactively. The results are formatted and printed on the standard output device (the screen). Use QUIT or EXIT to exit from isql.
If you do not specify a user name when you start isql, SQL Server 2000 checks for the environment variables and uses those, for example, isqluser=(user) or isqlserver=(server). If no environment variables are set, the workstation user name is used. If you do not specify a server, the name of the workstation is used.
If neither the -U or -P options are used, SQL Server 2000 attempts to connect using Windows Authentication Mode. Authentication is based on the Windows NT account of the user running isql.
see details in http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_isql_8r39.asp
- Difference between isql.exe and osql.exe while executing sql script
- What is the difference between an EXE and a DLL?
- Error executing link.exe.
- Error executing cl.exe
- OSQL/ISQL——SQL SERVER中的SQL*PLUS
- The difference between (()) and ().
- difference between "<" and "<<"
- [sql server] 在isql、osql、sqlcmd中调用脚本执行
- ISQL,OSQL使用说明
- isql和osql
- .NET调用osql.exe执行sql脚本创建表和存储过程<转> 代码
- .NET调用osql.exe执行sql脚本创建表和存储过程
- .NET调用osql.exe执行sql脚本创建表和存储过程
- What is the difference between ./ and sh to run a script?
- What is the difference between using a script and an animation?
- What is the difference between angle bracket < > and double quotes " " while including header files
- What is the difference between << and += while injecting elements to Hash.new([])?
- What’s the difference between “Array()” and “[]” while declaring a JavaScript array?
- 昨天发现新的问题
- 一个比较好的asp类
- 利用adsutil.vbs脚本创建自定义web站点
- 什么是RSS?
- 8088 汇编速查手册
- Difference between isql.exe and osql.exe while executing sql script
- c#.net常用的小函数和方法集
- Tomcat性能调整
- 7月7日
- 一个简单实用的遗传算法c程序(转载)
- 紧急求助:输出有误的迷宫问题程序
- 提交中文问题解决GET/POST
- NHibernate日期类型的映射(转)
- 这以后的,周鸿祎和互联网 Web2.0