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