°ïÎÒ½²½âÏÂÒ»¸ö¼òµ¥µÄ½¨±íSQLÓï¾ä£¬2005¶¼¿´²»¶®ÁË

USE [MYBASE]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [KA].[USERINFO](
[user_id] [nchar](20) NOT NULL,
[user_name] [nchar](10) NULL,
[user_password] [nchar](10) NULL,
[user_auth] [nchar](4) NULL,
CONSTRAINT [PK_USERINFO] PRIMARY KEY CLUSTERED
(
[user_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [KA]
) ON [KA]
GO
SET ANSI_PADDING OFF
GO

ÎÒÏëÖ´ÐÐÉÏÃæµÄSQLÓï¾ä¡£µ«²»³É¹¦£¬Çë°ïÎÒ½²½âһϡ£

MYBASEÊÇÊý¾Ý¿âÃû£¬ÎÒÒÑн¨Á˸ÃÊý¾Ý¿â¡£
KAÊÇʲô£¿ÎÒÀí½âΪÓû§£¬µ«ÎÒÒѾ­½¨Á¢Á˸ÃÓû§¡£ÏµÍ³ÌáʾSchemas²»¶Ô£¬ÎÒÓÖ½¨Á¢ÁËÃû½ÐKAµÄSchemas£¬ÏµÍ³ÓÖÌáʾInvalid filegroup 'KA' specified.

ÎÒ¸ÃÔõô²ÅÄÜÕýÈ·Ö´ÐÐÉÏÃæµÄÓï¾ä£¬Çë´ó¼Ò°ïÎÒ½âÊÍһϡ£2005¿´²»¶®ÁË¡£°¥¡£¡£¡£

---

KAÊÇÎļþ×é.

---

Îļþ×é

---

Îļþ×é

---

´´½¨MybaseµÄʱºòÒª´´½¨filegroupµÄ£¬Èç¹ûÄã²»ÊÇÓÃprimaryµÄgroupµÄ»°
²Î¿¼ÕâÑùµÄ´´½¨Êý¾Ý¿â·½·¨

SQL code:

CREATE DATABASE Mybase

ON



KA(

NAME = mybaseLog,

FILENAME = 'D:\mybase.mdf',

SIZE = 500MB,

MAXSIZE = 5000MB,

FILEGROWTH = 20MB )

---

ÎÒÔö¼ÓÁËÎļþ×éºóÔÙÖ´