Tham khảo tài liệu 'mastering sql server 2000- p3', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 70 CHAPTER 3 OVERVIEW OF SQL SERVER DB-Library Options Tab One of the features that makes SQL Server such a powerful tool is the variety of methods that you can use to retrieve data from it. You can execute Transact-SQL code using tools such as Query Analyzer or the OSQL command line tool or you can write your own custom programs. DB-library is one of the tools available for writing custom programs using a language like C or Visual Basic. DB-library is an application programming interface API which is a collection of functions and commands that developers can access through their own code. Using APIs developers do not need to rewrite code that Microsoft has already written. This makes the developer s job much easier. As Microsoft makes changes and updates to the code in SQL Server the DB-library API gets upgraded which means that you may occasionally need to get a new copy from the Microsoft Web site. To ascertain which version of the API you have loaded on your system check the DB-library information box at the top of the DB-Library Options tab. This tells you the version size and date of the DB-library file you are using. Not only can you view the version of the DB-library installed on your machine using the DB-Library Options tab you can also set two options that can change the way your DB-library works Automatic ANSI to OEM Conversion This setting will allow the DB-library to convert data from the client OEM into data that SQL Server will understand ANSI and vice versa. Use International Settings This setting will allow the DB-library to get date time and currency formats from the server instead of you having to hard code the formats into all your applications. PROGRAMS INSTALLED WITH SQL SERVER 71 Network Libraries Tab The sole function of the Network Libraries tab is to display the version number and date of the network library files that you have installed on your local system. If your files are out of date you can upgrade them by installing the latest .
