Wednesday, January 31, 2007

SQL SERVER:-WHAT IS THE DIFFERENCE BETWEEN ISQL AND OSQL

Both are command prompt utilities but as per HELP:-

The isql utility allows you to enter Transact-SQL statements, system procedures, and script files; and uses DB-Library to communicate with Microsoft® SQL Server™ 2000.

And

The osql utility allows you to enter Transact-SQL statements, system procedures, and script files. This utility uses ODBC to communicate with the server.

Use OSQL whenever possible as it supports UNICODE which ISQL doesnt.
---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Labels:

0 Comments:

Post a Comment

<< Home