| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Transact-SQL User's Guide |
![[-]](/dwicons/i_colpse.gif)
| Chapter 1 SQL Building Blocks |
Chapter 1
|
| SQL in Adaptive Server |
| Queries, data modification, and commands |
| Tables, columns, and rows |
| The relational operations |
![[+]](/dwicons/i_expand.gif)
| Compiled objects |
|
| Naming conventions |
| SQL data characters |
| SQL language characters |
|
| Identifiers |
|
| Expressions in Adaptive Server |
|
| Arithmetic and character expressions |
|
| Relational and logical expressions |
|
| Transact-SQL extensions |
| The compute clause |
| Control-of-flow language |
| Stored procedures |
| Extended stored procedures |
| Triggers |
| Defaults and rules |
| Error handling and set options |
| Additional Adaptive Server extensions to SQL |
|
| Compliance to ANSI standards |
| Federal Information Processing Standards (FIPS) flagger |
| Chained transactions and isolation levels |
|
| Identifiers |
| SQL standard-style comments |
| Right truncation of character strings |
| Permissions required for update and delete statements |
| Arithmetic errors |
| Synonymous keywords |
| Treatment of nulls |
|
| Adaptive Server login accounts |
| Group membership |
| Role membership |
| Getting information about your Adaptive Server account |
| Changing your password |
|
| Understanding remote logins |
|
| How to use Transact-SQL with the isql utility |
| Default databases |
| Using network-based security services with isql |
| Logging out of isql |
|
| Using the pubs2 and pubs3 sample databases |
| What is in the sample databases? |
|
|