Авторизация
Поиск по указателям
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
Предметный указатель
abs function Aggregate functions aggregate functions, AVG aggregate functions, COUNT aggregate functions, GROUP BY clause and aggregate functions, GROUP BY clause and, ORDER BY CLAUS and aggregate functions, HAVING clause and aggregate functions, MAX 2nd aggregate functions, MIN 2nd aggregate functions, SUM aggregates aggregates, nesting aggregates, nulls and Aliases aliases, column aliases 2nd aliases, table aliases aliases, table aliases, as table qualifiers ALTER COLUMN command ALTER TABLE command 2nd 3rd and operator AND operator, WHERE clause, SELECT statement ANSI JOIN SQL syntax ASC function auditing subqueries AVG function 2nd BETWEEN operator BETWEEN operator, WHERE clause, SELECT statement 2nd BIGINT data type BINARY data type 2nd binary intersection binary set difference binary unions Bit data type 2nd BNF (Backus Naur Form) Cartesian product Cartesian product, CROSS JOIN and CAST conversion function CAST function Ceiling function CHAR data type 2nd CHARACTER data type character data types character data types, CHAR data type character data types, NCHAR data type character data types, NVARCHAR data type character data types, selecting character data types, TEXT data type character data types, Unicode character strings character data types, VARCHAR data type CHARINDEX function 2nd CHECK constraint CHECK integrity constraint color coding, query editor column aliases Columns columns, joins columns, table definitions columns, tables columns, tables, adding, ALTER TABLE command columns, tables, aliases columns, tables, arithmetic operations columns, tables, data types, ALTER TABLE command columns, tables, deleting, ALTER TABLE command columns, UNION ALL operation columns, UNION set operation Commands commands, ALTER COLUMN commands, ALTER TABLE 2nd 3rd commands, CREATE DATABASE commands, CREATE INDEX commands, CREATE SYNONYM commands, CREATE TABLE 2nd commands, CREATE VIEW commands, DECLARE commands, delete 2nd commands, DELETE FROM commands, DROP COLUMN commands, DROP CONSTRAINT commands, DROP INDEX commands, DROP SYNONYM commands, DROP TABLE commands, DROP VIEW commands, INDEX BY commands, INNER JOIN commands, insert commands, INSERT INTO...SELECT commands, INSERT...INTO commands, JOIN commands, SELECT commands, SET commands, update 2nd commands, USE comments, statements concatenation, string functions constants, UNION operation Constraints constraints, check constraints, deleting constraints, NOT NULL constraints, PRIMARY KEY 2nd constraints, referential integrity constraints, unique conversion functions conversion functions, CAST 2nd conversion functions, CONVERT conversion functions, STR CONVERT function 2nd correlated queries correlated subqueries 2nd correlated subqueries, EXISTS predicate correlated subqueries, IN predicate correlated subqueries, NOT EXISTS predicate COUNT function 2nd 3rd COUNT function, IS NOT NULL condition COUNT function, IS NULL condition CREATE DATABASE command CREATE INDEX command CREATE INDEX statement CREATE SYNONYM command CREATE TABLE command 2nd CREATE TABLE statement CREATE VIEW command CROSS JOIN CROSS JOIN query option data in views data type precedence, parentheses Data types data types, BIGINT data types, BINARY data types, BIT data types, CHAR data types, CHARACTER data types, character data types data types, character data types, CHAR data type data types, character data types, NCHAR data type data types, character data types, NVARCHAR data type data types, character data types, selecting data types, character data types, TEXT data type data types, character data types, Unicode character strings data types, character data types, VARCHAR data type data types, date and time data types data types, DATETIME data types, DEC data types, DECIMAL data types, float data types, IMAGE data types, INT data types, INTEGER data types, long data types, miscellaneous data types data types, miscellaneous data types, BINARY data type data types, miscellaneous data types, BIT data type data types, miscellaneous data types, IMAGE data type data types, miscellaneous data types, monetary data types data types, miscellaneous data types, SQL_VARIANT data type data types, miscellaneous data types, TABLE data type data types, miscellaneous data types, UNIQUEIDENTIFIER data type data types, miscellaneous data types, XML data type data types, MONEY data types, NATIONAL CHARACTER data types, NCHAR data types, number data types data types, numeric data types, numeric, integers data types, NVARCHAR data types, selection tips data types, SMALLDATETIME data types, SMALLINT data types, SMALLMONEY data types, SQL VARIANT data types, Text data types, TINYINT data types, UNIQUE IDENTIFIER data types, VARBINARY data types, VARCHAR data types, VARCHAR2 Data types, XML databases databases, creating databases, deleting databases, master databases, model databases, msdb databases, system, default databases, tempdb date and time data types date functions date functions, DATE TIME data type date functions, DATEADD date functions, DATEDIFF date functions, DATEPART date functions, DAY date functions, formats date functions, GETDATE date functions, MONTH 2nd date functions, YEAR DATE TIME data type DateAdd function 2nd DateDiff function 2nd DATEFORMAT function DatePart function 2nd DATETIME data type Day function 2nd DEC data type DECIMAL data type decimal data types declare command Delete command 2nd DELETE FROM command deleting deleting, constraints deleting, databases deleting, indexes deleting, tables, DELETE command derived structures derived structures, query development and derived structures, tables, temporary derived structures, views derived structures, views, column alises derived structures, views, creating views derived structures, views, data in derived structures, views, ORDER BY claus derived structures, views, SELECT INTO statement derived structures, views, using views DESC function Designer tab difference operation, NOT IN predicate displaying data, SELECT statement DISTINCT function 2nd 3rd DROP COLUMN command DROP CONSTRAINT command DROP INDEX command DROP INDEX statement DROP SYNONYM command DROP TABLE command DROP VIEW command entering queries entering statements Environment tab equi-joins equi-joins, non-equi joins ER diagram error messages, viewing executing queries executing queries, stopping execution existential qualifiers EXISTS keyword EXISTS predicate, correlated subqueries Expressions expressions, parentheses in expressions, parentheses in, data type precedence and expressions, parentheses in, operator precedence and extraction, string functions float data type Floor function foreign keys foreign keys, referential integrity constraints Formats FROM, SELECT statement FULL OUTER JOIN Functions functions, ABS functions, aggregate functions functions, aggregate functions, AVG 2nd functions, aggregate functions, COUNT 2nd 3rd functions, aggregate functions, MAX functions, aggregate functions, MIN functions, aggregate functions, SUM 2nd functions, ASC functions, CEILING functions, conversion functions, conversion, CAST functions, conversion, CONVERT 2nd functions, conversion, STR functions, date functions functions, date functions, DATEADD 2nd functions, date functions, DATEDIFF 2nd functions, date functions, DATEPART 2nd functions, date functions, DAY 2nd functions, date functions, GETDATE 2nd functions, date functions, MONTH functions, date functions, YEAR 2nd functions, DATEFORMAT functions, DESC functions, FLOOR functions, LIKE functions, numeric functions, row-level functions functions, row-level functions, arithmetic operations on columns functions, row-level functions, DISTINCT 2nd functions, row-level functions, IS NOT NULL functions, row-level functions, IS NULL functions, row-level functions, ISNULL functions, row-level functions, NULLIF 2nd functions, row-level functions, ROUND 2nd functions, row-level functions, TOP 2nd 3rd functions, ROWCOUNT 2nd functions, SET DATEFORMAT functions, SORT functions, SQUARE
Реклама
|
|
О проекте