SQL Hacks

Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

Symbols

" (quotes, double)

for spaces in table and column names, Spaces in table names and column names

handling in Unicode output, Processing required

# (pound sign), indicating temporary table in SQL Server, Create a Temporary Table

% (percent sign)

modulus operator, Hacking the Hack

wildcard character, Solve a Crossword Puzzle Using SQL

& (ampersand)

append operator, Filling a Table with Words

SQL files imported into Oracle, Import a file of SQL into Oracle

' (apostrophe), escaping in SQL, Fix the Bug

' (quotes, single)

' OR ''=' and SQL injection attacks, Exploit the Bug

escaping, Filling a Table with Words

XSLT transformation, Hacking the Hack

handling in Unicode output, Processing required

(semicolon)

replacing GO instructions in SQL Server, SQL Server

separating statements, How to Use This Book

* (asterisk) wildcard, Solve a Crossword Puzzle Using SQL, Hacking the Hack

+ (string concatenation) operator, How to Use This Book, SQL Server and Access, Reduce the Precision of a Number

.mdb files, Import a file of SQL commands

.NET framework, Compiling C#

404 errors, Check for broken links

< (redirection) operator, Pipe into SQL

? (question mark)

placeholders, Filter ...