|
|
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
|
|