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
Interprocess Communications in Linux: The Nooks and Crannies
Summary
Summary
Creating and Accessing Semaphore Sets
Summary
A.2. Manual Page Format
VBScript Programmers Reference
Control of Flow
Remote Scripting
Appendix G The Windows Script Host Object Model
Appendix H Regular Expressions
Appendix K The Variant Subtypes
Adobe After Effects 7.0 Studio Techniques
Effects & Presets
Onward to Effects
Extending a Track with Expressions
Conclusion
Film, HDR, and 32 Bit Compositing
Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
Conclusion
Office Automation Executables
VSTO Support for Word Schema Mapping
How a COM Add-In Is Registered
Shimming: A Solution to the Problems with MsCoree.dll
MPLS Configuration on Cisco IOS Software
OSPF PE-CE Routing Protocol Overview, Configuration and Verification
Implementing Route-Reflectors in MPLS VPN Networks
Command Reference
Configuring L2TPv3 Tunnels for Layer 2 VPN
Command Reference
VBScript in a Nutshell, 2nd Edition
VBScripts History and Uses
WSH Language Elements
What Can You Do with Client-Side Scripting?
WSC Programming Topics
Section A.15. String Manipulation
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