SQLServer插入数据

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