SQLServer插入数据-优快云博客

本文链接：https://blog.youkuaiyun.com/iteye_21104/article/details/82448966

本文介绍了一个用于创建图书信息表的SQL脚本，并包含了插入几条具体图书记录的示例。该表包括图书ID、名称、作者、出版社及价格等字段。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

create database demodb

USE [demodb]
GO

/****** Object:  Table [dbo].[t_book]    Script Date: 12/13/2012 17:28:38 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[t_book](
	[id] [int] NOT NULL,
	[name] [varchar](20) NULL,
	[auther] [varchar](20) NULL,
	[press] [varchar](20) NULL,
	[price] [money] NULL,
 CONSTRAINT [PK_t_book] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [id]
      ,[name]
      ,[auther]
      ,[press]
      ,[price]
  FROM [demodb].[dbo].[t_book]

delete FROM [demodb].[dbo].[t_book]

insert into [demodb].[dbo].[t_book] values(1,'秘密','拜恩','中国城市出版社',17.3);
insert into [demodb].[dbo].[t_book] values(2,'白鹿原','陈忠实','北京十月文艺出版社',22);
insert into [demodb].[dbo].[t_book] values(3,'青春','韩寒','湖南人民出版社',20.3);
insert into [demodb].[dbo].[t_book] values(4,'追风筝的人','胡赛尼','上海人民出版社',16.3);
insert into [demodb].[dbo].[t_book] values(5,'狼图腾','姜戎','长江文艺出版社',21.1);
insert into [demodb].[dbo].[t_book] values(6,'正能量','理查德 怀斯曼民','湖南文艺出版社',18.5);
insert into [demodb].[dbo].[t_book] values(7,'好妈妈胜过好老师','尹建莉','作家出版社',14.3);
insert into [demodb].[dbo].[t_book] values(8,'你若安好便是晴天','白落梅','中国华侨出版社',17.4);
insert into [demodb].[dbo].[t_book] values(9,'不一样的卡梅拉','克利斯提昂','二十一世纪出版社',26.5);
insert into [demodb].[dbo].[t_book] values(10,'因为痛 所以叫青春','金兰都','广西科学技术出版社',19.7);