SQL Server Management Studio (SSMS)教程：创建数据库create database、创建表create table、新增数据insert、查询数据select

红太狼 2024-02-05 18:07 10阅读 0赞

![在这里插入图片描述][417b896c35e14aff962bf3e13e3208c0.png]

USE master
    GO
    IF NOT EXISTS (
       SELECT name
       FROM sys.databases
       WHERE name = N'TutorialDB'
    )
    CREATE DATABASE [TutorialDB]
    GO
    
    
    
    USE [TutorialDB]
    -- Create a new table called 'Customers' in schema 'dbo'
    -- Drop the table if it already exists
    IF OBJECT_ID('dbo.Customers', 'U') IS NOT NULL
    DROP TABLE dbo.Customers
    GO
    -- Create the table in the specified schema
    CREATE TABLE dbo.Customers
    (
       CustomerId        INT    NOT NULL   PRIMARY KEY, -- primary key column
       Name      [NVARCHAR](50)  NOT NULL,
       Location  [NVARCHAR](50)  NOT NULL,
       Email     [NVARCHAR](50)  NOT NULL
    );
    GO
    
    -- Insert rows into table 'Customers'
    INSERT INTO dbo.Customers
       ([CustomerId],[Name],[Location],[Email])
    VALUES
       ( 1, N'Orlando', N'Australia', N''),
       ( 2, N'Keith', N'India', N'keith0@adventure-works.com'),
       ( 3, N'Donna', N'Germany', N'donna0@adventure-works.com'),
       ( 4, N'Janet', N'United States', N'janet1@adventure-works.com')
    GO
    
    -- Select rows from table 'Customers'
    SELECT * FROM dbo.Customers;
    SELECT * FROM Customers;
    
    
    -- GETDATE函数
    select GETDATE();

--------------------

links:  
[  
https://learn.microsoft.com/zh-cn/sql/ssms/quickstarts/ssms-connect-query-sql-server?view=sql-server-ver16][https_learn.microsoft.com_zh-cn_sql_ssms_quickstarts_ssms-connect-query-sql-server_view_sql-server-ver16]

[417b896c35e14aff962bf3e13e3208c0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/8f5554bf8c704457b1ab34e21dce7108.png
[https_learn.microsoft.com_zh-cn_sql_ssms_quickstarts_ssms-connect-query-sql-server_view_sql-server-ver16]: https://learn.microsoft.com/zh-cn/sql/ssms/quickstarts/ssms-connect-query-sql-server?view=sql-server-ver16