Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
variables, 68
@@error, 74-75
@@identify, 73-74
@@rowcount, 75-76
assigning values in the Update statement, 72
assigning values with the Select statement, 70-72
assigning values with the Set statement, 72
declaring, 69
displaying values of, 72-73
global, 73-76
local, 69-73
naming conventions, 630-631
scalar functions, 73
table, 76-77
version control, 502
See also Visual SourceSafe
VIA, 5
viewing code of stored procedures, 43-44
views
common table expressions (CTEs), 234-237
design of standard SQL views, 228-229
Design view in Enterprise Manager, 230, 231
distributed partitioned, 244-248
dynamic, 234
editing data using, 233
exporting and importing, 256
improving performance, 259
indexed, 239-241
INFORMATION_SCHEMA, 237-238
limitation of, 232
nonclustered indexes on, 241
partitioned, 241-256
reducing complexity, 257-259
security, 230, 256
standard SQL views in execution plans, 231-232
syntax, 229-230
temporary, 234-237
triggers on, 275-278
virtual tables, inserted and deleted, 264-266
Visual SourceSafe, 502-503
adding database objects in the traditional way, 513-517
adding database objects in Visual Studio .NET, 505-507
administering, 504-505
Create scripts, 506-507, 507-509
creating Create scripts using Script Wizard, 513-516
creating scripts using TbDbScript, 516-517
Explorer, 509-513
history of changes in, 510-511
labels and versions, 511-513
putting scripts into with TbDir2Vss.vbs, 517
Visual Studio .NET
deploying Create scripts in, 535-537
incremental builds, 538
managing Create scripts in, 507-509
scripting data in, 526-527
VSS. See Visual SourceSafe
Категории