Seagate ST43401N/ND Información técnica descargar pdf (Pagina 91)

Migrating to Sybase Adaptive Server Enterprise 11.5 6-11

Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x or 11.0.x

• isnull Function in Object Code 6-11

• Increased Memory Requirements 6-12

• Additional Devices and Databases 6-17

• Optional Space Considerations 6-18

New Reserved Words in Version 11.5

The following words are reserved as of version 11.0 and can no

longer be used as database object, user, group, or role names:

isnull Function in Object Code

The isnull issue affects only upgrades from:

• 10.0.2 through 10.0.2.6

• 11.0 through 11.0.2

The

isnull system function allows you to substitute a value for a

NULL in certain instances, for example when inserting a value from

a column that contains a NULL to a column that is NOT NULL. The

syntax is:

isnull(expression1, expression2)

where expression1 is potentially NULL and expression2 is the value

to substitute. For example, you might use the function to substitute

zero for NULL as follows:

isnull(interest, 0)

When moving from an affected release to 11.5, you may encounter a

problem when expression1 and expression2 are of differing

datatypes. The issue arises only when the

isnull function is used in

Transact-SQL code that results in a stored query tree, as in stored

Table 6-4: New reserved words in 11.5

activation identity_start

connect membership

consumers passwd

exclusive proxy

external session

1 2 ... 86 87 88 89 90 91 92 93 94 95 96 ... 171 172

Sin comentarios

Seagate ST43401N/ND Información técnica Pagina 91