SqlServer数据库的基本操作

 

SqlServer数据库的基本操作：

https://docs.microsoft.com/zh-cn/sql/ssms/tutorials/connect-query-sql-server?view=sql-server-ver15

 

1.创建数据库

USE master

GO

IF NOT EXISTS (

   SELECT name

   FROM sys.databases

   WHERE name = N'TutorialDB'

)

CREATE DATABASE [TutorialDB]

GO

2.在数据库中创建表

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

3.将行插入新表

-- 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

4.查询并查看结果

-- Select rows from table 'Customers'
SELECT * FROM dbo.Customers;