TAILIEUCHUNG - Microsoft SQL Server 2008 R2 Unleashed- P15

Microsoft SQL Server 2008 R2 Unleashed- P15:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 94 CHAPTER 4 SQL Server Management Studio Projects and solutions are maintained and displayed with the Solution Explorer. The Solution Explorer contains a tree-like structure that organizes the projects and files in the solution. It is a component window within SSMS that you launch by selecting View Solution Explorer. Figure shows an example of the Solution Explorer. The solution in this example is named Employeeupgrade and it contains two projects named Phasel and Phase2. Each project contains a set of connections a set of T-SQL scripts and a set of miscellaneous files. FIGURE Solutions and projects listed in the Solution Explorer. The first thing to do when using the project management capabilities in SSMS is to add a project. To do this you select File New and when the New dialog appears you select Project to add a new project. When adding the new project you are given a choice of the type of project and you must select either SQL Server Scripts Analysis Services Scripts or SQL Mobile Scripts. Each one of these project types is geared toward the respective SQL Server technology. The solution that is related to the project is created at the same time that the project is created. The Solution Name is entered at the bottom of the New Project window and an option to create a separate directory for the solution is provided. There is no option to create the solution separately. After the project is added you can add the related connections and files. To add a new connection you simply right-click the Connections node. The Connections entries allow you to store SQL Server connection information that relates to the project you are working on. For example you could have a connection to your test environment and another Download from Development Tools 95 connection to the production environment that relates to the project. When a connection is included in the project you can double-click it and a new query window for that connection is .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.