F


federated servers, 244

alternative to, 255-256

Fetch statements, 96

flow-control statements, 77

Begin…End statements, 80-81

comments, 78-80

GoTo statements, 89-90

If statements, 81-86

WaitFor statements, 90

While statements, 86-89

four-part names, 54

full-text indexing and querying, 446-448

FullText Search, 5, 447

fully qualified names, 54

functions

aggregate, 132-134

as check and default constraints, 104

conversion, 115-118

date and time, 121-124

in expressions, 103

for handling identity values, 120-121

for handling null values, 113-115

instead of tables, 104-105

metadata, 131-132

as part of the selection criteria, 103

pass-through, 136-138

ranking, 134-136

returning current session information, 118-120

rowset, 136-142

scalar, 106-136

in selection and assignment, 102-103

side-effects, 306

string, 124-130

syntax, 102

table-valued, 104-105

user-defined, 304-314




Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL &  .NET
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
ISBN: 0072262281
EAN: 2147483647
Year: 2006
Pages: 165

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