INTRODUCTION Table 1-1: New Data Types in SQL:1999

INTRODUCTION Table 1-1: New Data Types in SQL:1999 Data Type Description BOOLEAN Bit switch BLOB Binary large object CLOB Character large object Structured types Distinct types and user-defined types REF Pointer to a persisted structured type Array Array LOCATORs Pointers to types inside the DBMS DATALINK Reference to an external data source In addition, complex type specific methods could be defined, and the SQL language was extended to support using attributes of a complex type in queries. An example of a complex type and a SELECTstatement that uses it would look like the following. SELECT ADDRESS FROM ADDR_TAB WHERE ADDR.addr_city like Sea% SQL:1999 expanded the type system to add some less revolutionary types, such as the BOOLEAN data type (which can contain TRUE, FALSE, or NULL) and the LOCATOR and DATALINK data types, which point to other storage inside or outside the database. A complete list of the new types is shown in Table 1-1. User-Defined Types and SQL Server SQL Server has always supported its own concept of a user-defined data type. These data types are known as alias types and are defined by using the system stored procedure sp_addtype. These data types share some functionality with SQL distinct types. They must be derived from a SQL Server built-in data type. You can add integrity constraints by using SQL Server RULEs. You create a SQL Server RULE using CREATE RULE and associate a rule with a SQL Server user-defined type by using sp_bindrule. A single user-defined data type can be used in multiple tables, and a single

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Tomcat Web Hosting services

Bookmark the permalink.

Comments are closed.