Index

Search in book...
Toggle Font Controls
Create new playlist

Name your new playlist

Playlist description (optional)
Sign In

Email address

Password

Forgot Password?

or

Continue with Facebook

Continue with Google
Sign Up

Full Name

Email address

Confirm Email Address

Password

or

Continue with Facebook

Continue with Google

Previous Chapter

Appendix D: SQLCMD Quick Reference

Index

A

Accumulate() method

Adjacency list model

ADO.NET 4.5. See also Asynchronous programming data services

System.Data.Common

System.Data namespace

System.Data.Odbc

System.Data.OleDb

System.Data.SqlClient

System.Data.SqlTypes

AdventureWorks OLTP and databases

Aggregate and analytic functions

windowing specifications

American National Standards Institute (ANSI)

Analytic functions. See also Aggregate and analytic functions

CUME_DIST and PERCENT_RANK functions

FIRST_VALUE and LAST_VALUE

PERCENTILE_CONT and PERCENTILE_DISC function

Application programming interface (API)

ASP.NET Web Services (ASMX)

Association for Computing Machinery (ACM)

Asymmetric encryption

algorithms and limits

ALTER ASYMMETRIC KEY statement

AsymKeylD function

BACKUP/RESTORE statements

CREATE ASYMMETRIC KEY statement

EncryptByCert and DecryptByCert

SignByAsymKey function

Asynchronous programming

stored procedure

Atomic data types

B

Books Online (BOL)

Bulk Copy Program (BCP)

C

CASE expressions

CHOOSE function

COALESCE and NULLIF functions

control-of-flow statements

BEGIN and END keywords

IF…ELSE statement

RETURN statement

WAITFOR statement

WHILE, BREAK, and CONTINUE statements

administrative tasks

ALTER INDEX statement

cursor-based Index

dbo.RebuildIndexes procedure

design patterns

@IndexList table

T-SQL extended syntax

dynamic queries

nvarchar variable

SQL table queries

static pivot table

search expression

simple expression

three-valued logic

IS NULL and IS NOT NULL

quick reference chart

explicit and effective permissions

inheritance model

querying permissions

table and column metadata

Certificate authority (CA)

Change Data Capture (CDC)

Check constraint

CHOOSE function

Closed-world assumption (CWA)

CLR integration programming

AUTHORIZATION clause

CREATE ASSEMBLY statement

.NET namespaces and classes

Open Data Services

stored procedures

Environment.GetEnvironmentVariables() functions

GetEnvironmentVars() method

SampleProc class

SendResultsStart() method

INSERT/UPDATE statement

Transaction.Current.Rollback() method

user-defined aggregates

advanced creation

user-defined data types

IsNull and Null properties

math operator methods

static properties

ToString() method

user-defined functions

CREATE FUNCTION statement

EmailMatch function

EXTERNAL_ACCESS

fill-row method

GetYahooNews() function

Clustered indexes

COALESCE and NULLIF functions

COALESCE() function

Command-line options

Common Language Runtime (CLR)

Common Object Request Broker Architecture (CORBA)

Common table expression (CTE)

Common table expressions (CTE)

definition and declaration

GetNamesCTE and GetContactCTE

readablility benefits

recursive queries

MAXRECURSION option

name and column list

SELECT statement

Computed constructors

Conditional expressions (if…then…else)

CONTAINS predicates

boolean operators

FORMSOF generation

prefix searches

proximity search

Context item expression

Control-of-flow statements

BEGIN and END keywords

IF…ELSE statement

RETURN statement

WAITFOR statement

WHILE, BREAK, and CONTINUE statements

CUME_DIST and PERCENT_RANK functions

administrative tasks

ALTER INDEX statement

cursor-based Index

dbo.RebuildIndexes procedure

design patterns

@IndexList table

T-SQL extended syntax

D

Database console commands (DBCCs)

Database master and encryption key

Database master key (DMK)

ALTER MASTER KEY statement

CREATE MASTER KEY statement

DROP MASTER KEY

ENCRYPTION BY PASSWORD clause

RESTORE MASTER KEY statement

Data Control Language (DCL)

Data Definition Language (DDL)

CREATE TABLE statement

CREATE TRIGGER statement

DROP TRIGGER statement

EVENTDATA() function

event types and groups

nodes() and value() methods

Data domain and page

DATALENGTH() function, while

Data Manipulation Language (DML)

CREATE TRIGGER statement

CASE expression

CREATE TRIGGER statement

@@ROWCOUNT function

SELECT statement

trigger logging table

UPDATE Statement

disable and enable

HumanResources.Employee table

INSERT and DELETE statement

multiple triggers

nested and recursive triggers

@@ROWCOUNT function

SELECT and UPDATE

SET NOCOUNT ON statement

UPDATE() and COLUMNS_UPDATED() functions

COLUMNPROPERTY() function

trigger definition

UPDATE statement

Data services. See also Service Oriented Architecture (SOA); SQL Server 2012 Express LocalDB

asynchronous programming

stored procedure

Java Database Connectivity (JDBC)

Class.forName()

javac command line

sqljdbc4.jar file

Open DataBase Connectivity (ODBC)

Apt-cache command

build_dm.sh command

unixodbc driver

application project

consumer application

entity data model

Data Transformation Services (DTS)

DATALENGTH() function, while

DATEDIFF() and DATEADD() functions

DATEDIFF() function

BETWEEN operator

standard time zones

access and manipulate

configuration information

filegroup creation

hierarchyid data types

adjacency list model

descendant nodes

INNER JOIN and LEFT OUTER JOIN

materialized path model

materials table

nested sets model

LEN() string function

string concatenation

decomposing space

flat representation

geography instance

INDEX statement

instance hierarchy

latitude-longitude

MultiPolygon object

orientation and hemisphere

STIntersects() method

wyoming polygon

uniqueidentifier

NEWID() function

NEWSEQUENTIALID() function

creation options

FLWOR expression

query execution cost

table valued function

modify() method

typed xml variable/column

untyped xml variables

Date and time data types

DATEDIFF() and DATEADD() functions

DATEDIFF() function

CONVERT() function

FORMAT() function

Format() method

SET LANGUAGE command

SWITCHOFFSET() function

SYSDATETIMEOFFSET() function

TODATETIMEOFFSET() function

BETWEEN operator

standard time zones

Debugging tools

PRINT statement

SSMS integration

Visual Studio T-SQL debugger

dbo.uspGetBillOfMaterials procedure

parameter values

Declarative language. See Imperative vs. declarative languages

Declarative referential integrity (DRI)

Distributed Component Object Model (DCOM)

Dynamic management functions (DMFs) See also Dynamic management views and functions

Dynamic management views (DMVs) See also Dynamic management views and functions

Dynamic management views and functions

connection information

expensive queries

blocked queries

cached query plan

ALTER INDEX statements

stored procedure

temporary objects

INFORMATION_SCHEMA views

column information

server resources

configuration details

instance keys and values

volume information

session information

OPTION (FORCE ORDER)

sys.dm_exec_requests

statistical semantics

semantickeyphrasetable

sys.dm_fts_parser function

sys.fulltext_index_fragments

sys.sp_fulltext_resetfdhostaccount procedure

tempdb space system

object allocations

debugging and troubleshooting code

EXECUTE statement

EXECUTE statement

T-SQL string validation function

E

asymmetric keys

algorithms and limits

ALTER ASYMMETRIC KEY statement

AsymKeylD function

BACKUP/RESTORE statements

CREATE ASYMMETRIC KEY statement

EncryptByCert and DecryptByCert

SignByAsymKey function

BACKUP CERTIFICATE statement

CREATE CERTIFICATE statement

DecryptByCert function

EncryptByCert function

SignByCert function

database master key

ALTER MASTER KEY statement

CREATE MASTER KEY statement

DROP MASTER KEY

ENCRYPTION BY PASSWORD clause

RESTORE MASTER KEY statement

extensible key management

service master keys

ALTER and DROP SYMMETRIC KEY statements

CLOSE SYMMETRIC KEY statement

CREATE SYMMETRIC KEY statement

EncryptByKey and DecryptByKey functions

KeyGUID function

metadata format

WITH PASSWORD clause

transparent data encryption

Enterprise Manager (EM)

Entity data model (EDM)

Entity framework (EF)

database objects

entity data model

pluralize/singularize

querying entities

AddObject() method

data modification

INSERT operation

SaveChanges() method

@@error system function

OUTPUT parameter

PRINT statement

RAISERROR statement

TestError procedure

RAISERROR statement

THROW statement

TRY_CAST function

TRY…CATCH model

CATCH block functions

XACT_STATE function

TRY_CONVERT function

ExecuteNonQuery() method

EXECUTE statement

Extended events (XEvents)

page splits or locking

performance tuning session

table pop-up context menu

Extensible key management (EKM)

EXtensible markup language (XML). See also XSL transformations

typed xml variable/column

untyped xml variables

DOM representation

edge table format

existing table schem

explicit schema

rowset provider

FOR XML EXPLICIT

Extensible Stylesheet Language (XSL) See also XSL transformations (XSLT)

Extract Transform Load (ETL) tool

F

FILESTREAM data types

configuration information

filegroup creation

parent path_locator

FileTableRootPath() function

GetFileNamespacePath()

GetPathLocator() function

hierarchyid functions

manipulate and access

Filtered indexes

FIRST_VALUE and LAST_VALUE function

FLWOR expressions

filter expression

order by clause

for and return Keywords

Foreign key constraint

ELEMENTS option

FOR XML EXPLICIT

FOR XML PATH clause

FREETEXT predicate

Full-text catalog

Full-text index

Full-text search (FTS)

context menu option

T-SQL statements

CONTAINS predicates

boolean operators

FORMSOF generation

prefix searches

proximity search

dynamic management views and functions

statistical semantics

sys.dm_fts_parser function

sys.fulltext_index_fragments

sys.sp_fulltext_resetfdhostaccount procedure

FREETEXT predicate

FREETEXTTABLE and CONTAINSTABLE functions

inflectional forms

ALTER FULLTEXT INDEX statement

change-tracking option

column selection

single-column unique

T-SQL statements

wizard selection

thesauruses and stoplists

replacement patterns

Functions and Operators (F&O)

G

General comparison operators

heterogeneous sequence

mix and match nodes

XQuery data format

Geography Markup Language (GML)

Global allocation map (GAM) pages

H

Heterogeneous sequence

Hierarchyid data types

adjacency list model

descendant nodes

INNER JOIN and LEFT OUTER JOIN

materialized path model

materials table

nested sets model

Homogenous sequence

I

IDENTITY properties

Imperative vs. declarative languages

Independent Software Vendor (ISV)

Index allocation map (IAM)

clustered indexes

execution plans

extended events

page splits or locking

performance tuning session

table pop-up context menu

filtered indexes

guaranteed order

nonclustered indexes

bookmark lookup

B-tree structure

covering indexes

lookup operation

row identifiers (RIDs)

optimizing queries

reading query plans

Indirect recursion

Inflectional form

INFORMATION_SCHEMA views

column information

Initialization vector (IV)

Inline function. See Table-valued functions (TVFs)

J, K

Java Database Connectivity (JDBC)

Class.forName()

javac command line

sqljdbc4.jar file

L

LAG and LEAD functions

Language Integrated Query (LINQ)

entity framework

database objects

entity data model

pluralize/singularize

querying entities

object/relational mapping (O/RM)

Legacy error handling

@@error system function

OUTPUT parameter

PRINT statement

TestError procedure

LEN() string function

Linux. See Open DataBase Connectivity (ODBC)

List data types

LocalDB (Local Database runtime). SQL Server 2012 Express LocalDB

CREATE TRIGGER statement

EVENTDATA() function

ROLLBACK TRANSACTION statement

sample data table

M

Materialized path model

string concatenation

Metadata discovery

Multiple active result sets (MARS)

connection string

single connection

Multiple-document interface (MDI)

Multistatement function. See Table-valued functions (TVFs)

N

Naming conventions

Nested sets model

.NET client programming See also Language Integrated Query (LINQ) ADO.NET

System.Data.Common

System.Data namespace

System.Data.Odbc

System.Data.OleDb

System.Data.SqlClient

System.Data.SqlTypes

ExecuteScalar() method

multiple active result sets

connection string

single connection

parameterization

ExecuteReader() method

SELECT statement

SqlDbType enumeration

Nonclustered indexes

bookmark lookup

B-tree structure

covering indexes

lookup operation

row identifiers (RIDs)

PARTITION BY and ORDER BY

O

Object-relational mapping (O/RM)

OFFSET and FETCH clause

client-side paging

Open DataBase Connectivity (ODBC)

Apt-cache command

build_dm.sh command

unixodbc driver

Open Data Services (ODS)

Open-world assumption (OWA)

DOM representation

edge table format

existing table schema

explicit schema

rowset provider

Optional occurrence indicator

OVER clause. See Aggregate and analytic functions

P

Parameterization

Path. See XPath

Path expression. See Location path

PERCENTILE_CONT and PERCENTILE_DISC function

Performance enhancement and tuning

clustered indexes

execution plans

extended events

filtered indexes

guaranteed order

nonclustered indexes

optimizing queries

reading query plans

SQL Server storage

data compression

files and filegroups

space allocation

Pivot tables. See CASE expressions

Primary expression

PRINT statement

Procedural code programming. See CASE expressions

Q

R

RAISERROR statement

RANK and DENSE_RANK functions

PARTITION BY clause

Row constructor

Row identifiers (RIDs)

ROW_NUMBER function

S

Scalar function

common table expression

CREATE FUNCTION statement

creation-time options

ENCRYPTION option

procedural code

AdventureWorks database

CASE expressions

CREATE TABLE statement

dbo.EncodeNYSIIS function

encodes strings

INSERT statement

NYSIIS encoding rules

SOUNDEX algorithm

RETURNS keyword

SELECT statements

Server certificate

Service master keys (SMK)

Service Oriented Architecture (SOA)

contracts layer

WCF data service

application project

WCF layers stack

Shared global allocation map (SGAM) pages

Simple Object Access Protocol (SOAP)

SOA (Service Oriented Architecture). See Service Oriented Architecture (SOA)

SOUNDEX algorithm

Spatial data types

decomposing space

flat representation

geography instance

INDEX statement

instance hierarchy

latitude-longitude

MultiPolygon object

orientation and hemisphere

STIntersects() method

wyoming polygon

Spatial index and data

sp_executesql stored procedure

client-side parameterization

dynamic SQL executes

parameterization

CREATE TABLE statement

decimal columns

decimal.Parse() method

destination table

DoImport() function

LoadSourceFile()

SELECT statement

SQL client (SQLNCLI)

data access connection

DATA_SOURCE connection

SqlConnection connection string keys

SqlDataReader instance

try…catch blocks

disconnected dataset

disconnected datasets

System.Data classes and enumerations

SQL CLR assemblies

command-line options

scripting variable

SETVAR and SET option

SQL Common Language Runtime (SQL CLR)

SQL Distributed Management Objects (SQL-DMO)

EXECUTE statement

T-SQL string validation function

editing filters

SQL Server 2012. See also SQL Server Management Studio (SSMS)

AdventureWorks OLTP and databases

Bulk Copy Program

extended events

integration services

editing filters

interactive screen

osql command-line

scripting variables

SQL Server Data Tools

SQL Server Data Tools (SSDT)

SQL Server 2012 Express LocalDB

AttachDBFilename

automatic instances

create and start option

localdb keyword

.mdf and .ldf file

MSI installations

security models

SQL Server Integration Services (SSIS)

SQL Server Management Studio (SSMS)

custom snippet command

insert and surround command

context-sensitive

CREATE TABLE statement

Help Viewer option

editing options

Enterprise Manager and Query Editor

graphical query execution

properties window

GUI database tools

keyboard shortcut schemes

Object Explorer

database tables

filtering objects

project management features

SELECT statement

source control options

T-SQL debugging

breakpoints and Datatip

locals and output windows

SQL Server 2012 Native Client (SNAC). See SQL Server 2012 Express LocalDB

SQL Server storage

data compression

files and filegroups

page compressions

anchor record value

column-prefix compression

duplicate values

page-dictionary compression

recommendations

row compressions

ALTER TABLE statement

clustered index

vardecimal compression options

space allocation

data allocation

dbo.LargeRows query

estimated I/O cost

nonsparse tables

SQL server, UTF-16

collation names

unicode data types

SSMS integration

Stoplists. See also Thesauruses and stoplists

Stored pocedures (SPs). See also Dynamic management views and functions; sp_executesql stored procedure

cache and reuse query execution

calling function

ALTER PROCEDURE and DROP PROCEDURE statements

EXECUTE statement

MARS Connection

Person.GetContactDetails

Person.GetEmployee

WITH RESULT SETS option

CREATE PROCEDURE

DROP PROCEDURE statement

Environment.GetEnvironmentVariables() functions

GetEnvironmentVars() method

managing statement

metadata discovery

ORDER BY clause

ProductID and ProductSubcategorylD

recommended products

recompilation and caching

dbo.GetRecompiledProcs

EXECUTE statement

GetProcStats Procedure

nonclustered index

parameter sniffing

parameter value

query plan optimization

dbo.MoveOneDisc

dbo.SolveTowers

Hanoi puzzle solution

RETURN statement

SampleProc class

SELECT and RETURN statement

SendResultsStart() method

table-valued parameters

CREATE TYPE statement

table structure

TotalQtyOrdered

user-defined functions

Structural query language (SQL)

deferred query execution

server and database

view and select tables

object/relational mapping (O/RM)

Structured Query Language (SQL). See also Transact-SQL (T-SQL)

check constraints

foreign key constraints

order of execution

relational model

three-valued logic

stored procedures (SPs)

transaction log

Symmetric encryption

ALTER and DROP SYMMETRIC KEY statements

CLOSE SYMMETRIC KEY statement

CREATE SYMMETRIC KEY statement

EncryptByKey and DecryptByKey functions

KeyGUID function

metadata format

WITH PASSWORD clause

T

Table-valued functions (TVFs)

inline function

CASE expressions

CREATE FUNCTION statement

FnCommaSplit function

Num and Element

SELECT statement

string-splitting function

bin-packing problem

CREATE FUNCTION keyword and RETURNS clause

individual inventory and sales detail items

INSERT INTO and SELECT clauses

InventoryDetails subquery

loop-based solution

product pull list

WHERE/JOIN clause

Table-valued parameters

CREATE TYPE statement

table structure

Tabular Data Stream (TDS)

TDE. See Transparent data encryption (TDE)

Thesauruses and stoplists

replacement patterns

Three-valued logic (3VL)

IS NULL and IS NOT NULL

quick reference chart

THROW statement

Transactional Control Language (TCL)

Transact-SQL (T-SQL)

defensive coding

naming conventions

one entry and one exit

SELECT * statement

variable initialization

imperative vs. declarative languages

stored procedures

transaction logs

user-defined functions

Transparent data encryption (TDE)

Triggers. See also Data Manipulation Language (DML)

CREATE TABLE statement

CREATE TRIGGER statement

DROP TRIGGER statement

EVENTDATA() function

event types and groups

nodes() and value() methods

INSERT/UPDATE statement

CREATE TRIGGER statement

EVENTDATA() function

ROLLBACK TRANSACTION statement

sample data table

Transaction.Current.Rollback() method

TRY_CAST function

TRY…CATCH exception handling

CATCH block functions

XACT_STATE function

TRY_CONVERT function

TRY_PARSE command

U

Union data types

Uniqueidentifier data types

NEWID() function

NEWSEQUENTIALID() function

UPDATE() and COLUMNS_UPDATED() functions

COLUMNPROPERTY() function

User-defined aggregates (UDAs)

Accumulate() method

advances creation

Read() and Write() methods

statistical median

Terminate() method

statistical range

struct declaration

Terminate() function

User-defined data types

IsNull and Null properties

math operator methods

static properties

ToString() method

User-defined functions (UDFs) See also Table-valued functions (TVFs)

CREATE FUNCTION statement

EmailMatch function

EXTERNAL_ACCESS

fill-row method

GetYahooNews() Function

deterministic function

nondeterministic functions

scalar function

CASE expression

common table expression

CREATE FUNCTION statement

creation-time options

ENCRYPTION option

procedural code

RETURNS keyword

SELECT statements

User-defined type (UDT)

collation names

unicode data types

V

Value comparison

Visual Studio T-SQL debugger

dbo.uspGetBillOfMaterials procedure

parameter values

W

Web Services (WS)

Well-formed XML

Well-known text (WKT)

Window functions. See also Aggregate and analytic functions

PARTITION BY and ORDER BY

OFFSET and FETCH clause

client-side paging

RANK and DENSE_RANK functions

OrderMonth column

PARTITION BY clause

ROW_NUMBER function

Windowing functions

Windows Communication Foundation (WCF). See also Service Oriented Architecture (SOA)

application project

consumer application

PopulateDropDown() function

service reference

UpdateImage() function

data service, payload types

application project

entity access rules

entity data model

service entity/operation

WITH XMLNAMESPACES clause

World Wide Web Consortium (W3C)

X, Y, Z

xml data type. See XQuery

COALESCE() function

ExecuteXmlReader() method

XmlReader class

columns without names and wildcard expressions

data() function

data() node test

element-centric format

element grouping

text() function

WITH XMLNAMESPACES clause

FOR XML PATH clause

XML path language

arithmetic expressions

axis specifiers

comment node test query

comparison, node

conditional expressions (if…then…else)

constructors and casting

dynamic XML construction

attribute constructor

direct constructor

numeric predicate

expressions and sequences

filter expression

homogenous and heterogeneous sequences

primary expressions

singleton atomic values

FLWOR expressions

order by clause

for and return Keywords

built-in functions

sql column function

sql variable function

integer division operator

general comparisons

node comparisons

value comparison operators

processing-instruction node test

relational model

XML query language

XQuery comments

XQuery Data Model (XDM)

date/time types

XQuery/XPath Data Model (XDM)

XSL transformations (XSLT) See also Extensible Stylesheet Language (XSL)

assemblies, CLR

relational data convertion

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.