|
|
 |
| Авторизация |
|
|
|
| Поиск по указателям |
|
|
|
|
|
|
|
 |
|
|
|
| Cumming A., Russell G. — SQL Hacks |
|
|
|
| Предметный указатель |
strings
strings command (Unix)
stylesheet (gross.xsl)
stylesheets, XSLT
subqueries
SUBSTITUTE function, escaping single quotes
SUBSTR function
SUBSTR function (Oracle) 2nd
substring function
SUBSTRING_INDEX function
subtotals and values, getting in one query
subtracting to get days between
Sum function
support for SQL92 standard
suppressing >1 prompt
surrogate keys
survey results
SVG (scalable vector graphics), generating from SQL
SVG pie chart created directly from SQL
switches
switches, command line
SYS_GUID( ) function
SYS_GUID( ) function (Oracle)
table comparison and
table comparison script
Tables
tag clouds, calculating
tallying survey results into a chart
tax (progressive), applying
temp space, running out of
Temporary
temporary space
temporary table
temporary table, creating
temporary tables
temporary variables
testing against two-column subquery
testing if table exists before executing
testing INSERT transaction
testing the connection
testing two values from a subquery
testKey function
text, searching for keywords without LIKE
Tidy program
ties
ties (in top n queries)
Time [See also dates]
time zone, getting in Oracle
TIMESTAMP datatype 2nd
Timestamps
too many files
TOP function (SQL Server)
top keyword
top n query
top n rows in each group
TOP n \
TO_CHAR function (Oracle) 2nd 3rd 4th
TO_DATE function (Oracle)
TO_DAYS function (MySQL)
transaction isolation
transaction isolation level
transaction isolation level, querying
Transactions
transposition errors, finding
transposition errors, finding in numbers
traversing a simple tree
tree visualization
tree, implementing and querying
trends, uncovering in data
Triggers
TRUE and FALSE values
TRUE and FALSE values, Access
Tsearch2 module (PostgreSQL)
tunneling into from Access
tunneling into MySQL
tunneling into MySQL from Access
tunneling into other databases
turning derived table into
types of
uncovering trends in data
ungrouping data with repeated columns
Unicode
union-compatible result sets
unions 2nd
unique identifier
unique identifiers
unique sequential number generation
unique sequential numbers, generating
Universally Unique Identifier (UUID)
UNIX
UPDATE statement
UPDATE statements
UPDATE triggers
updates
updating in MySQL
used in INSERT statement
user accounts
user creation form
user interface controls
user permissions, setting on columns and rows
| user permissions, setting on rows
user, setting on rows and columns
user-supplied date values converted to date literals
userid
Usernames
users and administrators, creating
using a large buffer
using as server-side script for AJAX applications
using big buffer for queries returning many rows
using BLOBs
using for complicated UPDATEs
using in CROSS JOIN
using instead of string concatenations
using optimistic locking
using OVER clause with
using pessimistic locking
using SELECT instead of VALUES construct
using self-join
using series of round trips
using to preprocess SQL
using variable binding
using with CASE
using with complicated UPDATEs
using with LEFT OUTER JOIN
using with SUM
UUID
UUID (Universally Unique Identifier)
UUID function
Validation
values (infrequently changing), keeping track of
values and subtotal, getting
values and subtotals, getting in one query
VALUES list (INSERT ... VALUES)
VARBINARY datatype
VARBINARY datatype (SQL Server)
VARCHAR datatype
varchar size
variable binding
Variables
vendor-specific XML features
version number
version number of database system
Versions
versions, SQL conventions and
viewing hidden variables and cookies
views
Visual Basic
Web Data Administrator (SQL Server)
web interface to SQL
web log format, controlling 2nd
web page converted to
web pages (badly formed), cleaning up with Tidy
web server log files
web site for this book
Web-based applications
web-based interfaace
web-based interface
web-based interfaces
web-based SQL interface
web-based SQL interfaces
Webalizer
Webalizer DNS cache, accessing
Webalizer tool, using
WebSQL Console (SQL Server)
WHERE clause
whn (columns with a DATE type)
widespread support among database systems
Wikipedia
Wildcard
wildcard character
Wildcards
Windows
with a condition
WITH ROLLUP clause
wizards (Access)
words table, creating
working without
Xalan
Xalan utility
XHTML, translating into SQL
XML features
XML, vendor-specific features
xmllint
XPath expressions
XSLT
XSLT processing
XSLT processor and stylesheet
XSLT stylesheet (gross.xsl)
XSLT transformation
XSLT transformation of web page to SQL
XSLT transformation of web page to SQL, Mac OS X
xsltproc utility
Year function 2nd
year-to-date totals
year-to-date totals, reporting
\ 2nd 3rd
\Q \Q(back quotes) for spaces in table and column names
\\ (backslash)
_ (underscore)
|| (string concatenation) operator 2nd 3rd 4th
|
|
|
| Реклама |
|
|
|
|
|
О проекте