MSSQL Server 2019 学习

原创已于 2023-02-27 11:06:24 修改 · 617 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#学习 #数据库 #mysql

于 2022-07-23 20:18:09 首次发布

SQL_Server 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了如何在MS SQL Server 2019中使用AdventureWorks2019示例数据库进行学习。通过设置权限，进行数据库恢复操作，包括在SQL Server Management Studio (SSMS)中启动数据库恢复向导，选择设备，添加备份文件，并完成数据库的恢复过程。

MS SQL Server 2019 学习

一、示例数据库

AdventureWorks2019

增加Everyone，设置Full Control

Restore Database

Open SQL Server Management Studio (SSMS) and connect to your SQL Server.

Right-click Databases in Object Explorer > Restore Database... to launch the Restore Database wizard.

Select Device and then select the ellipses (...) to choose a device.

Select Add and then choose the .bak file you recently moved to the backup location.

Select OK to confirm your database backup selection and close the Select backup devices window.

测试一下：

USE AdventureWorks2019;
SELECT * FROM Person.Person;

-- Syntax for SQL Server and Azure SQL Database  
  
<SELECT statement> ::=    
    [ WITH { [ XMLNAMESPACES ,] [ <common_table_expression> [,...n] ] } ]  
    <query_expression>   
    [ ORDER BY <order_by_expression> ] 
    [ <FOR Clause>]   
    [ OPTION ( <query_hint> [ ,...n ] ) ]   
<query_expression> ::=   
    { <query_specification> | ( <query_expression> ) }   
    [  { UNION [ ALL ] | EXCEPT | INTERSECT }  
        <query_specification> | ( <query_expression> ) [...n ] ]   
<query_specification> ::=   
SELECT [ ALL | DISTINCT ]   
    [TOP ( expression ) [PERCENT] [ WITH TIES ] ]   
    < select_list >   
    [ INTO new_table ]   
    [ FROM { <table_source> } [ ,...n ] ]   
    [ WHERE <search_condition> ]   
    [ <GROUP BY> ]   
    [ HAVING < search_condition > ]