F


Index


[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

failed object creation, troubleshooting 2nd
FAST_FORWARD cursors
FETCH NEXT statement
fields
     definition of
fifth normal form
file system
     file placement 2nd
     filegroups 2nd
     filenames
     primary files
     secondary files
filegroups 2nd
FILEGROWTH clause (CREATE DATABASE statement)
filenames
files [See also file system]
     data files
     file placement 2nd
     filegroups 2nd
     filenames
     log files 2nd
     primary files
     secondary files
fill factor 2nd
Fill Factor option (server properties)
filtering
     data access 2nd
filtering data
     arithmetic operators
     BETWEEN keyword
     bitwise operators
     comparison operators 2nd
     EXISTS keyword
     IN keyword
     LIKE keyword 2nd
     logical operators 2nd
     NULL values 2nd
     unary operators
firing order of triggers 2nd 3rd
first normal form (1NF) 2nd
fixed roles
FLOOR() function
FOR XML clause (SELECT statement) 2nd
FOREIGN KEY constraints 2nd 3rd 4th
foreign keys 2nd
formatting data 2nd
Formula descriptor (columns)
FORWARD_ONLY cursors
fourth normal form
FROM clause (SELECT statement)
Full-Text catalogs 2nd
Full-Text indexes 2nd
full-text indexes 2nd
functions [See also global variables]
     ABS()
     ASCII()
     AVG()
     CAST() 2nd 3rd
     CEILING()
     CHAR()
     CHECKSUM()
     CHECKSUM_AGG()
     CHECKSUM_BINARY()
     COL_LENGTH()
     COL_NAME()
     CONVERT() 2nd
     COUNT()
     COUNT_BIG()
     DATALENGTH()
     DATEADD()
     DATEDIFF() 2nd
     DATENAME() 2nd
     DATEPART() 2nd
     DB_ID()
     DB_NAME()
     deterministic
     EXP()
     FLOOR()
     GETANSINULL()
     GETDATE()
     HOST_ID()
     HOST_NAME()
     IDENT_INCR()
     IDENT_SEED()
     INDEX_COL()
     ISNULL() 2nd
     LEN()
     LTRIM()
     MAX()
     MIN()
     nondeterministic 2nd
     NULLIF()
     OBJECT_ID()
     OBJECT_NAME()
     OPENQUERY
     OPENROWSET 2nd 3rd
     PATINDEX()
     PI()
     POWER()
     RAND()
     REPLICATE()
     REVERSE()
     ROUND()
     RTRIM()
     SPACE()
     SQRT()
     SQUARE()
     statistical functions 2nd 3rd
     STATS_DATE()
     STDDEV()
     STDDEVP()
     STUFF()
     SUBSTRING() 2nd 3rd
     SUM()
     SUSER_SID()
     SUSER_SNAME()
     T-SQL functions
     user-defined functions 2nd 3rd 4th
         creating 2nd
         definition of
     USER_ID()
     USER_NAME()
     VAR()
     VARP()



EXAM CRAM 2 Designing and Implementing Databases with SQL Server 2000 Enterprise
MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
ISBN: 0789731061
EAN: 2147483647
Year: 2005
Pages: 154

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net