sql server 存储过程,问题补充里的这句什么意思?
CONSTRAINT [PK_CUST_FUND] PRIMARY KEY CLUSTERED
(
[tx_date] ASC,
[done_no] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
追问:什么叫primary文件组?WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)是什么意思?谢谢啊..
答案:给[tx_date]、[done_no] 两个字段添加联合主键,聚集索引约束
键名[PK_CUST_FUND],两字段升序排序,并保存于primary文件组
其他:添加一个主键吧,
with 里面都是些默认的属性。
你这个是右键出来的吧
上一个:SQL SERVER 2005问题,如何连接四个表,按照第一个表左连接,下面是语句,帮我看看哪儿错了
下一个:hibernate配置,链接sql server2005出问题