tailieunhanh - Querying, Managing, and Administering Databases Using SQL Server 2005

When you write stored procedures, triggers, and user-defined functions, you need to decide whether to use traditional Transact-SQL or a programming language that is compatible with the .NET Framework, such as Visual Basic .NET or C#. Transact- SQL is best for situations in which the code primarily performs data access with little or no procedural logic. Programming languages that are compatible with the .NET Framework are best-suited for computationally-intensive functions and procedures that feature complex logic or for situations where you want to take advantage of the .NET Framework class library. | Collaborate Chapter 1 Knowledge Byte In this section you will learn about .NET Framework SQL Server 2005 tools Grouping data by using the UNPIVOT operator .NET Framework Read the following topic in the Introduction to SQL Server 2005 section of Chapter 1 of the book Querying and Managing Data Using SQL Server 2005 The .NET Framework Working with SQL Server 2005 Tools Read the following section of Chapter 1 of the book Querying and Managing Data Using SQL Server 2005 Identifying the SQL Server 2005 Tools Grouping Data by Using the UNPIVOT Operator The UNPIVOT operator allows database users to normalize the data that has earlier been pivoted. The UNPIVOT operator transforms the multiple column values of a record into multiple records with the same values in a single column. For example a table that stores applicants records has one row for each applicant. The table stores the applicant s name qualification and grade. After applying the UNPIVOT operator on the table the table contains a different row for each qualification that the applicant has completed. NIIT Querying Managing and Administering Databases Using SQL Server 2005 .