Index_U

U

U (Update) locking mode, 501

UDDI Business Registry Node page, 628-629, 628-630

UDDI (Universal Description, Discovery, and Integration) service, 626

UDDI Test Environment option, 627, 630

UDDI Web Service Registration page, 627, 627

uid element in connection strings, 7

uint type, 269

UInt16 type, 269

UInt32 type, 269

UInt64 type, 269

ulong type, 269

Unchanged value

in DataRowState, 379

in DataViewRowState, 369, 456

Underline property, 538

UNICODE function, 114, 116

UNION cause, 76, 76

UNION ALL clause, 573

Unique property, 350-351, 353-354

UniqueConstraint objects

creating, 418-420

properties for, 418

purpose of, 143

uniqueidentifier column, 53

uniqueidentifier type, 44, 270

UniqueIdentifier value, 242

Universal Description, Discovery, and Integration (UDDI) service, 626

Unspecified value, 493

Update (U) locking mode, 501

Update method

in DataAdapter, 377-379

in SqlDataAdapter, 296

UPDATE permission, 38

UPDATE statement, 62, 83-84, 84

with browsers, 592, 592

with ExecuteNonQuery, 230-233

integrity with, 86

multiple, 286-288

UpdateCommand property

in DataAdapter, 374-376, 391-392, 398

setting, 381-382

in SqlDataAdapter, 296, 339

UpdateCustomerT1 method, 511-512

UpdateCustomerT2 method, 511, 513

UpdateProduct.sql stored procedure, 388

UpdateProductT1 method, 511-513

UpdateProductT2 method, 511-512

UpdateRowSource property, 208

UpdateRule property, 421, 428, 439-440

updates

DataRow objects, 434

failures in, 408-412

of primary keys, 437-443, 439

SQL Server for, 438, 439

UpdateRule property for, 439-440

UpdateUnitPriceProductTrigger.sql script, 131-133

UPPER function, 114-115

URLs

INSERT, UPDATE, and DELETE statements in, 592

SELECT statements in, 590-591

special characters in, 591

stored procedures in, 592-593

USE statement, 61

user-defined data types, 38

user-defined functions

inline table-valued, 121-122

multistatement table-valued, 122-124, 123-124

scalar, 119-121, 121

in SQL Server, 38

in T-SQL, 119

usernames, 15, 190

users in SQL Server, 36, 36

ushort type, 269

using statement, 7

UsingColumnOrdinals.cs program, 264-266

UsingDataView.cs program, 458-460

UsingDataView2.cs program, 461

UsingDataViewManager.cs program, 476-478

UsingDefaultSort.cs program, 460

UsingParameters.cs program, 244-245

UsingXmlDataDocument.cs program, 608-612

UsingXmlDocument.cs program, 604-606




Mastering C# Database Programming
Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver
ISBN: 0764596373
EAN: 2147483647
Year: 2003
Pages: 181

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