ANSI_PADDING 设置的问题,sql2005
GO/****** 对象: Table [dbo].[Shop] 脚本日期: 09/02/2010 09:31:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Shop](
[lngShopID] [int] IDENTITY(1,1) NOT NULL,
[lngRegionID] [int] NULL,
) ON [PRIMARY]
SET ANSI_PADDING OFF
ALTER TABLE [dbo].[Shop] ADD [lngShopLevel] [int] NULL
ALTER TABLE [dbo].[Shop] ADD [lngShopCostMoney] [decimal](10, 2) NULL
ALTER TABLE [dbo].[Shop] ADD [lngCommFlg] [int] NULL
ALTER TABLE [dbo].[Shop] ADD [lngOrderM] [int] NULL
ALTER TABLE [dbo].[Shop] ADD [lngOrderR] [int] NULL/****** 对象: Index [PK_Shop] 脚本日期: 09/02/2010 09:31:54 ******/
ALTER TABLE [dbo].[Shop] ADD CONSTRAINT [PK_Shop] PRIMARY KEY CLUSTERED
(
[lngShopID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
上面的脚本,我想改红色部分的 列的 ANSI_PADDING ON ,求解 --------------------编程问答-------------------- UP 一下,在线等解 。
红色的列我重新创建了,还是没用,郁闷
补充:.NET技术 , ASP.NET