tailieunhanh - Hướng dẫn học Microsoft SQL Server 2008 part 3

Và tất nhiên, các dependson câu trả lời bao nhiêu bạn thực sự cần biết về hệ thống cơ sở dữ liệu yêu thích của tôi. Đối với một số'',''có thể bao gồm informationneeded rất nhiều đất, nhưng cuốn sách của Paul tiến lại gần hơn để bao gồm tất cả mọi thứ hơn bất kỳ bookI có bao giờ thấy. | Contents Cursor scope .585 Cursors and transactions .585 Cursor Strategies .586 Refactoring Complex-Logic Cursors .587 Update query with user-defined function .588 Multiple queries .589 Query with case expression .590 Summary .591 Chapter 23 T-SQL Error Legacy Error Handling .593 @@error system function .594 @@rowcount system function .595 Raiserror .596 The simple raiserror form .596 The improved raiserror form .596 Error severity .597 Stored messages .597 .600 Catch block .601 Nested try catch and rethrown errors .603 T-SQL Fatal Errors .604 Summary .605 Chapter 24 Developing Stored Managing Stored Procedures .608 Create alter and drop .609 Executing a stored procedure .609 Returning a record set .610 Compiling stored procedures .610 Stored procedure encryption .610 System stored procedures .611 Using stored procedures within queries .611 Executing remote stored procedures .612 Passing Data to Stored Procedures .613 Input parameters .613 Parameter defaults .614 Table-valued parameters .616 Returning Data from Stored Procedures .618 Output parameters .619 Using the Return Command .620 Path and scope of returning data .621 Summary .622 Chapter 25 Building User-Defined Scalar Functions .625 Limitations .625 Creating a scalar function .625 Calling a scalar function .627 Inline Table-Valued Functions .627 Creating an inline table-valued function .628 Calling an inline table-valued function .628 Using parameters .629 Correlated user-defined functions .630 Creating functions with schema binding .632 Multi-Statement Table-Valued Functions .632 Creating a multi-statement table-valued function .633 Calling the function .634 Summary .634 Chapter 26 Creating DML Trigger Basics .635 Transaction flow .636 Creating triggers .637 After triggers .638 Instead of triggers .639 xx Contents Trigger limitations .640 Disabling triggers .641 Listing triggers .641 Triggers and security .642 Working with