首页 > 代码库 > 运用SET ANSI_PADDING OFF创建某个字段为自增列的表,以及插入数据

运用SET ANSI_PADDING OFF创建某个字段为自增列的表,以及插入数据

SET ANSI_PADDING OFF
GO
PRINT ‘Testing with ANSI_PADDING OFF‘
GO

CREATE TABLE WebsitesPaddingOFF
(id int IDENTITY(1,1) NOT NULL,
name char(16) NULL,
url varchar(50) NULL,
country varchar(16)NULL,
aleax int NULL)
GO
INSERT INTO WebsitesPaddingOFF VALUES (‘Google‘,‘https://www.google.cm/‘,‘USA‘,1)
INSERT INTO WebsitesPaddingOFF VALUES (‘淘宝‘,‘https://www.taobao.com/‘,‘CN‘,13)
INSERT INTO WebsitesPaddingOFF VALUES (‘菜鸟教程‘,‘http://www.runoob.com/‘,‘CN‘,4689)
INSERT INTO WebsitesPaddingOFF VALUES (‘微博‘,‘http://weibo.com/‘,‘CN‘,20)
INSERT INTO WebsitesPaddingOFF VALUES (‘Facebook‘,‘https://www.facebook.com/‘,‘USA‘,3)

GO

运用SET ANSI_PADDING OFF创建某个字段为自增列的表,以及插入数据