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

最新推荐文章于 2025-03-21 09:48:42 发布

学亮编程手记

最新推荐文章于 2025-03-21 09:48:42 发布

阅读量1.3k

点赞数 9

分类专栏：数据库文章标签：数据库 sql sqlserver

本文链接：https://blog.csdn.net/a772304419/article/details/135159287

版权

数据库专栏收录该内容

1200 篇文章

订阅专栏

在这里插入图片描述

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();