Chapter 5: New Features in Adaptive Server Version 12.5.0.x
New and changed Transact-SQL commands
Table 5-17 summarizes
the new Transact-SQL commands in version 12.5.0.1.
Table 5-17: New commands
Command
Description
grant
dbcc
Allows the System Administrator to grant
access on certain dbcc commands.
revoke
dbcc
Allows the System Administrator
to revoke access on some dbcc commands.
Table 5-18 summarizes
the changes to existing Transact-SQL commands in version 12.5.0.1.
Table 5-18: Changed commands
Command
Change
insert
You can use the insert command
to create a new file directory. To do so, use only the filename, filetype,
and content columns. Specify “DIR” as
the filetype, to create filename as a directory.