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

5-16 Implement: Making Required Application Changes

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

select title_id, avg_advance = avg(advance)

into #tempdata from titles

select title_id, avg(advance) avg_advance

into #tempdata from titles

select title_id, avg(advance) as avg_advance

into #tempdata from titles

If Your Current Version is 4.x or 10.x

Continue with this section if you are upgrading from SQL Server 4.x.

Begin here if you are upgrading from 10.x.

Skip this section if you are upgrading from version 11.0.x.

This section covers the following issues:

• New Reserved Words in Version 11.0 5-16

• Subquery Processing Changes 5-17

New Reserved Words in Version 11.0

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

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

names:

See “New Reserved Words in Version 11.5” on page 5-19 for reserved

words introduced in the next release.

See “Changing Reserved Words in Your Applications” on page 5-20

and “Using the set Command to Keep Object Names” on page 5-20

for information on how to ﬁnd and resolve reserved word conﬂicts.

Table 5-4: New reserved words in 11.0

max_rows_per_page

syb_terminate

partition

unpartition

online

1 2 ... 65 66 67 68 69 70 71 72 73 74 75 ... 171 172

Sin comentarios

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