|
|
| Book details / order |
| TRANSACT-SQL PROGRAMMING |
Transact-sql is a procedural language used on both microsoft sql server and sybase sql server systems. it is a full-featured programming language that dramatically extends the power of sql (structured query language).
the language provides programmers with a broad range of features, including:
* a rich set of datatypes, including specialized types for identifiers, timestamps, images, and long text fields
* local and global variables
* fully programmable server objects like views, triggers, stored procedures, and batch command files
* conditional processing
* exception and error handling
* full transaction control
* system stored procedures that reduce the complexity of many operations, like adding users or automatically generating html web pages
in recent years, the versions of transact-sql have diverged on microsoft and sybase systems; the book explains the differences. it also contains up-to-the-minute information on the latest versions: microsoft sql server versions 6.5 and 7.0 and sybase version 11.5.
a brief table of contents follows:
part i: the basics: programming in transact-sql
1. introduction to transact-sql
2. matching business rules
3. sql primer
4. transact-sql fundamentals
5. format and style
part ii: the building blocks: transact-sql language elements
6. datatypes and variables
7. conditional processing
8. row processing with cursors
9. error handling
10. temporary objects
11. transactions and logging
part iii: functions and extensions
12. functions
13. case expressions and transact-sql extensions
part iv: programming transact-sql objects
14. stored procedures and modular design
15. triggers
16. views
17. system and extended stored procedures and bcp
part v: performance tuning and optimization
18. transact-sql code design
19. code maintenance in the sql server
20. transact-sql optimization and tuning
21. debugging transact-sql programs
part vi: appendixes
a. system tables
b. what's new for transact-sql in microsoft sql server 7.0? c. bcp
the book comes with a cd-rom containing an extensive set of examples from the book and complete programs that illustrate the power of the language.
Author : Kevin kline, lee gould, andrew zanevsky
Publication : O'reilly
Isbn : 9788173660818
Store book number : 104
NRS 792.00
|
 |
|
|
|
|
|
|
|
| |
|
|
