N


n placeholder, 169

N+1 cluster configurations, 265–266

NAME keyword, 148, 154

name resolution, deferred, 391

Named Pipes components, 78

names

backup devices, 193

database, 432

SQL Server Backup General page, 195

namespaces, 100, 343

naming convention, SQL Server table, 27–28

Naming feature, CLS, 335

Native Client, SQL, 252

nchar data type, 304, 582

NCHAR function, 314, 582

nchar(n) data type synonyms, 308

Negative (–) operator, 559

Negative (-) unary operator, 299

nested expressions, 299

nested stored procedures, 412–413

nested triggers, 393

nested XML elements, 512

.NET Framework, 8–9, 79, 350–351, 385, 399

net send commands, 89–90

Net-Libraries, 51, 78–79

netmodules, 346

network addresses, default monitored, 80

Network attribute, 251–252

network bandwidth, 556

network configuration, Cluster Service, 271

network connections, 282

network considerations, modeling multinode server clusters, 276

Network Monitor Agent tool, 535

network names, 276, 284

New Database dialog box, Management Studio, 158–159

new media sets, SQL Server Backup Options page, 196

New Publication Wizard, Management Studio, 226–231

New Subscription Wizard, Management Studio, 221–226

new_table placeholder, 458

NEWID function, 168, 375, 428, 582

NEWNAME option, MODIFY FILE argument, 154

NEWSEQUENTIALID function, 583

NO ACTION events, 35

NO_WAIT argument, 155

nonclustered indexes, 33, 45, 169, 175, 376

nondeterministic functions, 310–311

nondeterministic resource cleanup, 341

nonoperational database mode, 200

nonrepeatable reads, 489

nontrusted access, 107–110, 117–118

non-Unicode data types, 303–305

normalization, 446

NOT (~) operator, Bitwise, 296

NOT BETWEEN expression, 462

not equal (<> or !=) operators, 462

Not Equal comparison operators, 297

Not Equal To (<>) operator, 561

Not Equal To (!=) operator, 561

NOT FOR REPLICATION arguments, 168–169, 376–377, 388

NOT function, 583

not greater than (!>) operator, 297, 462

Not Greater Than (!>) operator, 561

NOT IN keywords, 463

not less than (!<) operator, 297, 462

Not Less Than (!<) operator, 561

NOT logical operator, 298, 461

NOT NULL constraints, 35, 166, 375

NT File System (NTFS), 104

ntext data type, 304–305, 308, 583

NTFS (NT File System), 104

n-tier client/server systems, 15

NULL keyword

CONSTRAINT keyword, 375

in CREATE TABLE statements, 168

Data rule, 357

and DISTINCT argument, 454

in INSERT statements, 425–428

and logical database architecture, 28

and search condition, 462

and type integrity, 361

nullability of computed columns, 166

NULLIF function, 583

numeric constants, 293

numeric data type, 301, 574, 583

NUMERIC_ROUNDABORT Sql_option, ALTER DATABASE statements, 157

nvarchar data type, 304, 582

nvarchar(n) data type synonyms, 308




Microsoft SQL Server 2005. The Complete Reference
Microsoft SQL Server 2005: The Complete Reference: Full Coverage of all New and Improved Features
ISBN: 0072261528
EAN: 2147483647
Year: 2006
Pages: 239

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