Flylib.com
List of Sidebars
Previous page
Table of content
Next page
Preface
What Is a Sidebar?
Chapter 2: Fundamental SQL Concepts and Principles
ANSI/ISO Standard Documents
Chapter 3: SQL Data Types
Introducing Unicode
Character vs. Special Files
Precision and Scale for NUMERIC and DECIMAL Datatypes
Selecting Correct Data Types
Understanding TIMESTAMP WITH LOCAL TIME ZONE Data Type
Chapter 4: Creating RDBMS Objects
Using INITIALLY DEFERRED Constraints
Index Organized Tables and Other Physical Properties
Creating Summary Tables
Clustered Indexes
Simulating OR REPLACE Clause in MS SQL Server
Chapter 6: Data Manipulation Language (DML)
Archiving Based on Complex Business Rules
RDBMS error messages
Dangers of the WHERE Clause
Chapter 7: Sessions, Transactions, and Locks
Setting SQL*Plus Session Parameters
Orphaned Sessions
Explicit and Implicit Transactions
Nested Transactions
Distributed Transactions
Chapter 9: Multitable Queries
Fully Qualified Column Names
Chapter 10: SQL Functions
Getting Random Numbers in a Different Range
NULL and Aggregate Functions
Conversion Pitfalls
Chapter 11: SQL Operators
Why Operator Precedence Is Important
Using Boolean Logic for Data Safety
Chapter 12: SQL and RDBMS Security
Oracle 9
i
User PROFILE
SQL Server 2000 DENY Statement
OS Security Integration
How XOR Encryption Works
What Is C2 Security Level?
Chapter 13: The System Catalog and INFORMATION_SCHEMA
Getting Help
Chapter 14: Stored Procedures, Triggers, and User-Defined Functions
Sequential and Event-Driven Programming
Passing Parameters by Name and by Value
Chapter 15: Dynamic and Embedded SQL Overview
Embedded and Dynamic SQL Terminology
Embedded (Static) Versus Dynamic SQL: Advantages and Disadvantages
Chapter 16: SQL API
JDBC Connector and Java Data Objects (JDO)
Oracle Gateways
Microsoft DBLIB Legacy
Chapter 17: New Developments—XML, OLAP, and Objects
XML and Web Services
Future of XML
OLAP Rules
ROLAP, MOLAP, and HOLAP...
Collections and Arrays
Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory
Set Operations on Multielement Operands
Previous page
Table of content
Next page
Microsoft SQL Server 2008 Bible
ISBN: 0470257040
EAN: 2147483647
Year: 2005
Pages: 208
Authors:
Paul Nielsen
,
Uttam Parui
BUY ON AMAZON
Qshell for iSeries
The EDTF Text Editor
Scripting
Additional Control Structures
Functions
The Perl Utility
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
Defining Constants
Recipe 4-14. Displaying Error Bars
Calculating Confidence Intervals
Computing Confidence Intervals
Exploring Resource Allocation Optimization Problems
MySQL Clustering
Before You Begin with MySQL Cluster
Ensuring That MySQL Cluster Works
Cluster Topographies
Individual Programs
B Management Commands
GO! with Microsoft Office 2003 Brief (2nd Edition)
Project 1A. Windows XP
Problem Solving
Objective 11. Perform What-If Analysis
Getting Started with PowerPoint 2003
Summary
File System Forensic Analysis
Analysis Tools
Directory Entry
Summary
The Big Picture
UFS1 Superblock
GDI+ Programming with C#
Understanding GDI+
Rectangles and Regions
Manipulating Images
Marginal Printing: A Caution
Understanding the Rendering Process
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies