Авторизация
Поиск по указателям
Bagui S.S., Earp R.W. — Learning SQL on SQL Server 2005
Обсудите книгу на научном форуме Нашли опечатку?
Название: Learning SQL on SQL Server 2005Авторы: Bagui S.S., Earp R.W. Аннотация: Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.
Язык: Рубрика: Руководства по программному обеспечению /Статус предметного указателя: Готов указатель с номерами страниц ed2k: ed2k stats Год издания: 2006Количество страниц: 342Добавлена в каталог: 01.11.2006Операции: Положить на полку |
Скопировать ссылку для форума | Скопировать ID
Предметный указатель
functions, STR functions, string functions functions, string functions, CHARINDEX 2nd functions, string functions, concatenation functions, string functions, extraction functions, string functions, LEFT 2nd functions, string functions, LEN functions, string functions, LOWER functions, string functions, LTRIM functions, string functions, RIGHT 2nd functions, string functions, RTRIM 2nd functions, string functions, SUBSTRING 2nd functions, string functions, UPPER 2nd GETDATE function 2nd grid form, query results GROUP BY clause GROUP BY clause, aggregate functions and GROUP BY clause, aggregate functions and, ORDER BY clause and GROUP BY clause, DISTINCT function grouping, aggregates and GUID HAVING clause 2nd HAVING clause, aggregates and HAVING clause, WHERE clause and IMAGE data type 2nd IN operator IN predicate IN predicate, correlated subqueries IN predicate, joins, examples IN predicate, set operations IN predicate, subqueries and INDEX BY command Indexes indexes, deleting INNER JOIN command 2nd inner joins insert command INSERT INTO SELECT command INSERT INTO...SELECT command INSERT...INTO command int data type Integer data type integer data types Integrity constraints integrity constraints, CHECK integrity constraints, UNIQUE INTERSECT operator, set operations 2nd IS NOT NULL condition, COUNT function IS NOT NULL function IS NULL condition, COUNT function ISNULL function 2nd Join JOIN, associative property JOIN, CROSS JOIN JOIN, nested JOIN, OUTER JOIN JOIN, OUTER JOIN, FULL OUTER JOIN JOIN, OUTER JOIN, LEFT OUTER JOIN JOIN, OUTER JOIN, RIGHT OUTER JOIN JOIN, syntax JOIN, UNION and JOIN, WHERE clause and Joins joins, columns joins, equi-joins joins, IN predicate and, examples joins, INNER JOIN joins, inner joins joins, nested joins, non-equi-joins joins, ORDER BY clause and joins, outer joins joins, outer joins, full outer join joins, outer joins, left outer join joins, outer joins, right outer join joins, self-joins joins, Student_course database joins, subqueries as joins, tables, multiple Left function 2nd left join left outer join 2nd LEN string function 2nd LIKE clause LIKE function Load script, table creation long data type LOWER function LOWER string function LTRIM function LTRIM string function master database MAX aggregate function max function MIN aggregate function MIN aggregation function MINUS set operation miscellaneous data types miscellaneous data types, BINARY data type miscellaneous data types, BIT data type miscellaneous data types, IMAGE data type miscellaneous data types, monetary data types miscellaneous data types, SQL_VARIANT data type miscellaneous data types, TABLE data type miscellaneous data types, UNIQUEIDENTIFIER data type miscellaneous data types, XML data type model database monetary data types MONEY data type MONTH date function Month function msdb database NATIONAL CHARACTER data type NCHAR data type 2nd nested joins New Database dialog box non-equi-joins noncorrelated subqueries NOT BETWEEN operator NOT EXISTS operator NOT EXISTS predicate, correlated subqueries NOT IN predicate, set operations 2nd NOT NULL constraint NOT NULL operator NOT operator NULLIF function 2nd NULLL value nulls, aggregates and number data types, decimal data types numeric data type numeric data types, integers numeric functions NVARCHAR data type 2nd ON DELETE CASCADE option, referential integrity constraint ON DELETE NO ACTION option, referential integrity constraint ON UPDATE NO ACTION option, referential integrity constraint ON UPDATE option, referential integrity constraint Operators operators, AND operators, BETWEEN operators, IN operators, Not operators, NOT BETWEEN operators, NOT EXISTS operators, NOT NULL operators, OR operators, precedence, parentheses and operators, subqueries and OR operator OR operator, WHERE clause, SELECT statement ORDER BY clause ORDER BY clause, aggregate functions ORDER BY clause, joins and ORDER BY clause, SELECT statement ORDER BY clause, SELECT statement, ascending/descending order ORDER BY clause, SELECT statement, NULL value and ORDER BY clause, SELECT statement, order within order ORDER BY clause, views outer join 2nd OUTER JOIN, FULL OUTER JOIN OUTER JOIN, LEFT OUTER JOIN OUTER JOIN, RIGHT OUTER JOIN parentheses, expressions parentheses, expressions, data type precedence and parentheses, expressions, operator predecence and parsing queries PERCENT function PRIMARY KEY constraint 2nd 3rd primary keys printing query results qualifiers qualifiers, existential qualifiers, unversal Queries queries, correlated queries queries, CROSS JOIN queries, entering queries, error messages, viewing queries, executing queries, executing, stopping execution queries, parsing queries, printing queries, results queries, results, displaying queries, results, printing queries, results, saving to file queries, saving queries, subqueries queries, subqueries, auditing in queries, subqueries, IN predicates query development query development, derived structures and Query Editor Query Editor, color coding Query Editor, opening Query Editor, opening, New Query button Query Editor, opening, right-clicking Query Execution tab Query Results tab REAL data type referential integrity constraints REFRERENCES constraint results of queries results of queries, displaying results of queries, displaying, grid form results of queries, displaying, text form results of queries, saving to file RIGHT function 2nd RIGHT OUTER JOIN 2nd ROUND function 2nd row-level functions row-level functions, arithmetic operations on columns row-level functions, DISTINCT row-level functions, ISNULL row-level functions, NULLIF row-level functions, ROUND row-level functions, TOP row-level functions, TOP, PERCENT and ROWCOUNT function 2nd rows, tables rows, tables, displaying rows, tables, selecting RTRIM function 2nd Saving saving, queries saving, query results to file scripts, Student_course database Select command SELECT INTO statement, views SELECT statement SELECT statement, FROM and SELECT statement, ORDER BY clause SELECT statement, ORDER BY clause, ascending/descending order SELECT statement, ORDER BY clause, NULL value and SELECT statement, ORDER BY clause, order within order SELECT statement, WHERE clause SELECT statement, WHERE clause, AND operator SELECT statement, WHERE clause, BETWEEN operator 2nd SELECT statement, WHERE clause, OR operator self-joins set command SET DATEFORMAT function Set operations set operations, binary intersection set operations, binary set differences set operations, binary unions set operations, difference, NOT IN predicate set operations, IN predicate set operations, INTERSECT set operations, INTERSECT operator set operations, NOT IN predicate set operations, UNION 2nd set operations, UNION ALL 2nd set operations, UNION ALL, columns and set operations, union compatibility set operations, UNION, columns and set operations, UNION, JOIN and Sets SMALLDATETIME data type SMALLINT data type SMALLMONEY data type SORT function Souce Control tab SQL Server Management Studio, starting SQL_VARIANT data type 2nd Square function statements statements, comments statements, entering statements, writing Str function 2nd string functions string functions, CHARINDEX string functions, concatenation string functions, extraction string functions, LEFT string functions, LEN 2nd string functions, LOWER 2nd string functions, LTRIM 2nd string functions, RIGHT string functions, RTRIM string functions, substring string functions, UPPER strings strings, substrings, LIKE function strings, Unicode character strings Student_course database Student_course database, creating Student_course database, joins Student_course database, objects Student_course database, script Student_course database, tables Student_course database, tables, default subqueries subqueries, as joins subqueries, auditing in subqueries, IN predicate and subqueries, operators and substring function 2nd substrings, LIKE function
Реклама
|
|
О проекте