SQL Server Management Studio (SSMS) 教學課程Tutorials for SQL Server Management Studio (SSMS)

適用於: 是SQL Server 是Azure SQL Database 是Azure SQL 資料倉儲 是平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

SQL Server Management Studio (SSMS) 教學課程會向您介紹整合式環境,讓您管理您的 SQL ServerSQL Server 基礎結構。SQL Server Management Studio (SSMS) tutorials introduce you to the integrated environment for managing your SQL ServerSQL Server infrastructure. SQL Server Management StudioSQL Server Management Studio 提供圖形化介面,可用來設定、監視及管理 Azure SQL Database、Azure SQL Database 受控執行個體、Azure SQL 資料倉儲和 SQL ServerSQL Server 的執行個體。presents a graphical interface for configuring, monitoring, and administering Azure SQL Database, Azure SQL Database managed instance, Azure SQL Data Warehouse, and instances of SQL ServerSQL Server. 也讓您部署、監視以及升級應用程式所使用的資料層元件,例如資料庫。It also allows you to deploy, monitor, and upgrade the data-tier components used by your applications, such as databases. SQL Server Management StudioSQL Server Management Studio 也提供用於編輯和偵錯指令碼的 Transact-SQLTransact-SQL、MDX、DMX 和 XML 語言編輯器。also provides Transact-SQLTransact-SQL, MDX, DMX, and XML language editors for editing and debugging scripts.

學習內容What You Will Learn

本系列教學課程將協助您了解資訊在 SSMS 中的呈現方式,以及如何運用其功能。These tutorials will help you understand the presentation of information in SSMS and how to take advantage of its features.

熟悉 SSMS 的最佳方式是實際練習。The best way to get acquainted with SSMS is through hands-on practice. 本系列教學課程將讓您熟悉 SSMS 中可用的各項功能。These tutorials will familiarize you with the various features available within SSMS. 本系列教學課程會告訴您如何管理 SSMS 的元件及如何尋找您經常使用的功能。These tutorials will teach you how to manage the components of SSMS and how to find the features that you use regularly.

以下是這些教學課程所涵蓋的內容:Here is what the tutorials cover:

  • 教學課程:使用 SSMS 來連線及查詢 SQL ServerTutorial: Connect & Query SQL Server using SSMS

    在本教學課程中,您將學習如何連線至您的 SQL Server 執行個體。In this Tutorial, you learn how to connect to your SQL Server instance. 您也將學習一些基本的 Transact-SQL (T-SQL) 命令來建立和查詢新的資料庫。You will also learn some basic Transact-SQL (T-SQL) commands to create and then query a new database.

  • 教學課程:在 SSMS 中撰寫物件指令碼Tutorial: Scripting Objects in SSMS

    在本教學課程中,您將學習如何在 SSMS 中編寫各種物件的指令碼,包括資料庫和查詢。In this Tutorial, you learn how to script out various objects in SSMS, including databases and queries.

  • 教學課程:使用 SSMS 中的範本Tutorial: Using Templates in SSMS

    在本教學課程中,您將學習如何使用在 SSMS 中預先建立的範本。In this Tutorial, you learn how to work with the pre-built Templates within SSMS. 範本是鮮為人知的功能,其存放各種資料庫系統管理工作的大量 Transact-SQL 程式碼片段。The templates are a little-known feature that stores a number of Transact-SQL code snippets for various database administration tasks.

  • 教學課程:SSMS 設定Tutorial: SSMS Configuration

    在本教學課程中,您將學習設定 SSMS 環境的基礎,例如變更環境配置。In this Tutorial, you learn the basics of configuring your SSMS environment, such as the changing the environmental layout. 本教學課程也會說明各種不同的 SSMS 元件。This Tutorial also explains what the different SSMS components are.

  • 教學課程:使用 SSMS 的其他祕訣與訣竅Tutorial: Additional Tips and Tricks for using SSMS

    在本教學課程中,您會學習使用 SSMS 的其他提示與訣竅。In this Tutorial, you learn additional tips and tricks for using SSMS. 本教學課程包含下列項目:The Tutorial includes the following:

    • 註解、取消註解文字Commenting and uncommenting text
    • 縮排文字Indenting text
    • 在物件總管中篩選物件Filtering Objects in Object Explorer
    • 存取您的 SQL Server 錯誤記錄檔Accessing your SQL Server error log
    • 尋找您的執行個體名稱Finding the name of your instance


這個教學課程適合不熟悉 Visual StudioVisual Studio,但很熟悉資料庫概念和 Transact-SQLTransact-SQL 的資深資料庫管理員和資料庫開發人員。This tutorial is intended for experienced database administrators and database developers who are not familiar with Visual StudioVisual Studio, but who are familiar with database concepts and Transact-SQLTransact-SQL.

您必須已經安裝下列項目,才能使用這個教學課程:You must have the following installed to use this tutorial:

第一節將引導您建立資料庫,但如需其他範例資料庫,請參閱這裡:AdventureWorks 範例資料庫 (英文)。The first section walks you through creating a database but other sample databases can be found here: AdventureWorks Sample Databases. 如需有關在 SSMS 中還原資料庫的指示,請參閱這裡:還原資料庫Instructions for restoring databases in SSMS can be found here: Restoring a Database.

另請參閱See Also

Database Engine 教學課程Database Engine Tutorials