System changes in 12.5.3  New Transact-SQL functions

Chapter 3: New Features in Adaptive Server 12.5.2 and 12.5.3

Changes to commands

Table 3-1 summarizes the new Transact-SQL functions.

Table 3-1: Changes to commands

Function

Description

dbcc monitor

Adds increment, decrement, and reset. increment and decrement increase and decrease usage counts for the monitor counters in the specified group by 1. reset sets the usage count for the monitor counters in the specified group to zero. This turns off collection of monitoring data for this group.

alter table, create table

Adds the id parameter, which sets the identity column to int, smallint, tinyint, or numeric





Copyright © 2005. Sybase Inc. All rights reserved. New Transact-SQL functions

View this book as PDF