Transact-SQL desk reference - For Microsoft SQL server

Deac Lancaster

822 pages, parution le 01/12/2003

Ajouter à une liste

Indisponible

Résumé

Provides a user-friendly guide to the SQL database programming language. This command reference will be based upon the successful design of the Linux Desk Reference Designed for users, developers, and sys admins, it will provide a user-friendly guide to the SQL database programming language. All commands will be listed alphabetically by functional area, this is ideal for beginners who can locate commands based on the tasks they are trying to accomplish.

RDBMS Concepts - A Primer
- Database Management System Background
- SQL Language
- Client-Server Architecture
- RDBMS: Tables and Databases
- The SQL Language and MSS's Transact-SQL
- Lab Exercises
SQL Building Blocks and Server Settings
- SQL Server Instance
- Data Representation
- General Data Type Information
- Domain and NULL Value
- Expressions in an SQL Statement
- SQL Server 2K Data Types
- User-Defined Data Type
- Transact-SQL Functions
- System Stored Procedures and DBCC
- Server, Database and Session Settings
Data Definition Language and Security
- Data Definition Language (DDL)
- Displaying Metadata
- Security
- Lab Exercises
Data Manipulation Language-INSERT, UPDATE, DELETE, SELECT
- INSERT
- UPDATE
- DELETE
- TRUNCATE TABLE
- SELECT
- SET Operations
Transaction Control, Backup and Restore and Transact-SQL Programming
- Transaction Control-ANSI SQL and MSS
- Transaction Control : Isolation Levels
- Server Shutdown
- @@version
- BACKUP AND RESTORE
- Database Layout for Performance and Restorability
- Error Handling.
- Cursors
Appendices
Bibliography
Index

L'auteur - Deac Lancaster

DEAC LANCASTER has taught high-level programming courses at Sun Microsystems, Remedy Corporation, and University of California, Santa Cruz-extension for the past 13 years. He has over 20 years of computer programming experience.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Prentice Hall
Auteur(s)	Deac Lancaster
Parution	01/12/2003
Nb. de pages	822
Format	17,7 x 23,5
Couverture	Broché
Poids	1150g
Intérieur	Noir et Blanc
EAN13	9780130293398