Microsoft SQL Server 2005 Developer’s Guide- P2

Microsoft SQL Server 2005 Developer’s Guide- P2:This book is the successor to the SQL Server 2000 Developer’s Guide, whichwas extremely successful thanks to all of the supportive SQL Server developerswho bought that edition of the book. Our first thanks go to all of the peoplewho encouraged us to write another book about Microsoft’s incredible new relationaldatabase server: SQL Server 2005.
Nội dung trích xuất từ tài liệu:
Microsoft SQL Server 2005 Developer’s Guide- P2 Chapter 1: The Development Environment 19event handlers, and one tab for viewing the contents of a package. A fifth tab thatappears at run time allows you to view the execution progress of a package. After thepackage completes its run, the execution results can be viewed. The SSIS Designeris shown in Figure 1-11. Separate design surfaces exist for building the control flow, data flows, and eventhandler elements in packages. Dialog boxes and windows, such as the variablewindow and the breakpoint window, are also included to help you add and configurevariables and to troubleshoot your project. Wizards are included to add functionalityand advanced features.Import Analysis Services 9.0 Database The Import Analysis Service 9.0 Databaseproject enables you to create a new SQL Server 2005 Analysis Services project byimporting the definitions for an existing SQL Server 2000 Analysis Services or SQLServer 7 OLAP Server database.Report Project, Report Project Wizard, and Report Model Project The BI DevelopmentStudio contains the Report Project template, the Report Project Wizard template,Figure 1-11 SSIS Designer20 M i c r o s o f t S Q L S e r v e r 2 0 0 5 D e v e l o p e r ’s G u i d e and the Report Model Project template to create Reporting Services projects. These reporting templates are used to design reports and control their deployment. Reporting Services project templates start the Reporting Services Designer, where you can select data sources and visually lay out reports. Reporting Services projects, the Report Designer, and the Report Project Wizard are covered in more detail in Chapter 9. Properties Like the Properties window in SQL Server Management Studio, the BI Development Studio Properties window allows you to view the properties of files, projects, or solutions. The Properties window shown in the bottom-right corner of Figure 1-9 is used at design time to set the properties of the objects selected in the Solution Explorer. If the Properties window is not already displayed, you can show it by selecting the View | Properties Window option from the BI Development Studio menu. The Properties window displays different types of editing fields, depending on the type of object selected. Toolbox The Toolbox window in the BI Development Studio is shown on the left side of the screen in Figure 1-11. The Toolbox is used by the SSIS Designer and the Reporting Services Designer to drag and drop components onto their respective design surfaces. Output Window The Output window displays the results when a solution is built. You can see the Output window in the lower-middle portion of Figure 1-9. Summary The separate administrative tools that were used to manage the previous versions of SQL Server have been combined into one integrated environment, allowing the DBA to focus on managing the server objects more efficiently. In this chapter, you got a look at the new SQL Server Management Studio, which combines the four previous tools: Enterprise Manager, Query Analyzer, Profiler, and Analysis Manager. This chapter also gave you a view of the new Business Intelligence (BI) Development Studio, which is used to create Analysis Services databases, DTS packages, and Reporting Services reports. These environments definitely improve your effectiveness in developing SQL Server objects and managing SQL Server administration tasks. CHAPTER Developing with T-SQL 2 IN THIS CHAPTER T-SQL Development Tools Creating Database Objects Using T-SQL DDL Querying and Updating with T-SQL DML 21Copyright © 2006 by The McGraw-Hill Companies. Click here for terms of use.22 M i c r o s o f t S Q L S e r v e r 2 0 0 5 D e v e l o p e r ’s G u i d e S QL (Structured Query Language) is the standard language for relational database management systems (RDBMSs), and T-SQL is Microsoft’s version of the SQL language. T-SQL includes Data Definition Language (DDL) statements to create databases as well as database objects such as tables, views, indexes, and stored procedures. In addition, T-SQL also includes Data Manipulation Language (DML) statements that are used to query and update relational data stored. In the first part of this chapter you’ll learn about the tools that Microsoft provides for developing, debugging, and deploying T-SQL scripts. Next, with an understanding of the tools under your belt, you’ll learn in the second part of this chapter how T-SQL can be used to create database objects as well as how you can build T-SQL statements to query and update data. T-SQL Development Tools Microsoft provides two primary tools for developing T-SQL scripts. First, as a part of SQL Server 2005’s SQL Server Management Studio (SSMS), there’s the Query Editor, which provides a basic T-SQL development environment and is primarily intended to develop T-SQL DDL statements, perform performance tuning with graphical showplans, and run ad hoc queries. Next, to creat ...