Index
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
[X]
[Y]
data in views data type precedence, parentheses data types BIGINT BINARY BIT CHAR CHARACTER character data types CHAR data type NCHAR data type NVARCHAR data type selecting TEXT data type Unicode character strings VARCHAR data type date and time data types DATETIME DEC DECIMAL FLOAT IMAGE INT INTEGER LONG miscellaneous data types BINARY data type BIT data type IMAGE data type monetary data types SQL_VARIANT data type TABLE data type UNIQUEIDENTIFIER data type XML data type MONEY NATIONAL CHARACTER NCHAR number data types NUMERIC numeric, integers NVARCHAR selection tips SMALLDATETIME SMALLINT SMALLMONEY SQL VARIANT TEXT TINYINT UNIQUE IDENTIFIER VARBINARY VARCHAR VARCHAR2 XML databases creating deleting master model msdb system, default tempdb date and time data types date functions DATE TIME data type DATEADD DATEDIFF DATEPART DAY formats GETDATE MONTH 2nd 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 constraints databases indexes tables, DELETE command derived structures query development and tables, temporary views column alises creating views data in ORDER BY claus SELECT INTO statement 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
|