|
Free ebooks
 Free database ebooks SQL Inside Microsoft SQL Server 2005: T-SQL Programming
|
||||||||
 Chapter 1: Datatype-Related Problems, XML, and CLR UDTsIn this chapter, I'll cover some T-SQL programming issues related to datatypes, focusing on DATETIME, character manipulations, large objects, and new functionality in Microsoft SQL Server 2005. Chapter 2: Temporary Tables and Table Variables In this chapter, I will try to provide you with a clear picture of how the different temporary object types behave, in which circumstances you should use each, and whether you should use them at all. Chapter 3: Cursors In this chapter, I'll explain the types of problems for which cursors are a reasonable solution, even though such cases are not common. The goal of the chapter is to show you how to use them wisely. Chapter 4: Dynamic SQL Chapter 5: Views This chapter starts with a brief description of views and their uses. As the chapter progresses, I'll discuss details of working with views. Among other things, I'll cover the use of views to simplify your queries, and indexed views to improve the performance of your database. Chapter 6: User-Defined Functions This chapter explores the types of UDFs that are supported by SQL Server: scalar-valued UDFs, which return a single value, and table-valued UDFs (inline and multiple-statement), which return a table. Chapter 7: Stored Procedures This chapter explores stored procedures.The chapter covers the stored procedure's interface, resolution process, compilation, recompilations and execution plan reuse, the EXECUTE AS clause, and the new common language runtime (CLR) stored procedures. Chapter 8: Triggers In this chapter, I'll describe in detail the different types of triggers, first describing DML AFTER triggers and later, in a dedicated section, DDL AFTER triggers. Chapter 9: Transactions I will describe isolation levels in more detail later in the chapter. Later in the chapter, I will describe the new isolation levels and the circumstances in which you would benefit from using them. Chapter 10: Exception Handling In this chapter, I'll briefly go over the limitations of exception handling in SQL Server 2000 and then discuss the new functionality available in SQL Server 2005. Chapter 11: Service Broker In this chapter, I'll discuss the internal details of Service Broker and how it works, and I'll provide some compelling scenarios for using Service Broker in your database applications. Download free pdf ebooks of sql:Inside Microsoft SQL Server 2005: T-SQL Programming
|
| More free ebooks | |