|
|
Posted by Roy Harvey (SQL Server MVP) on 10/31/07 14:48
Put PRIMARY in [square brackets].
Roy Harvey
Beacon Falls, CT
On Wed, 31 Oct 2007 07:27:56 -0700, cong <franzcai80@gmail.com> wrote:
>On 10??31??, ????11??00??, "Roy Harvey (SQL Server MVP)"
><roy_har...@snet.net> wrote:
>> On Tue, 30 Oct 2007 22:13:05 +0000 (UTC), Erland Sommarskog
>>
>> <esq...@sommarskog.se> wrote:
>> >> When you get past that you will find that CLUSTERD is not the correct
>> >> spelling of the keyword CLUSTERED. And you might prefer to spell
>> >> ORIGIONAL as ORIGINAL, and if REPLYD is supposed to be the past tense
>> >> of REPLY then you might want REPLYED.
>> >Any particular reason he might want precisely that spelling? Do you
>> >happen to know that REPLYED is preferred over REPLIED in China? :-)
>>
>> I have no idea about what is preferred, except in English, but it
>> appeared that the names might be intended to be in English. Which is
>> why I said "might" and "perhaps".
>>
>> I once wrote an entire forecasting system, misspelling forecast as
>> forcast. I ended up fixing report headings when the users noticed,
>> but left all the variables and field names alone. The poor guy who
>> took over when I left knew how to spell it though and it drove him
>> nuts.
>>
>> Roy Harvey
>> Beacon Falls, CT
>
>if exists(select * from dbo.sysobjects where id =
>object_id(N'BBSItems')
>and OBJECTPROPERTY(id,N'IsUserTable')=1)
>drop table BBSItems
>GO
>
>CREATE TABLE BBSItems(
>ITEM_ID int IDENTITY(1,1) NOT NULL,
>ITEM_TITLE nvarchar(30) COLLATE Chinese_PRC_CS_AS NOT NULL,
>ITEM_CONTENT nvarchar(3000) COLLATE Chinese_PRC_CS_AS NOT NULL,
>COMPOSE_DATE smalldatetime NOT NULL,
>MODIFY_DATE smalldatetime NULL,
>IS_ORIGIONAL bit NOT NULL
>CONSTRAINT DF_BBSItem_IS_ORIGIONAL DEFAULT(0),
>AUTHOR nvarchar(15) COLLATE Chinese_PRC_CS_AS NOT NULL,
>FATHER_ID int NULL,
>REPLYD_TIMES smallint NOT NULL
>CONSTRAINT DF_BBSItem_REPLYD_TIMES DEFAULT(0),
>BROWSED_TIMES smallint NOT NULL
>CONSTRAINT DF_BBSItem_BROWSED_TIMES DEFAULT(0),
>LATEST_REPLICATION_ID int NULL,
>CONSTRAINT PK_BBSItems PRIMARY KEY CLUSTERED
>(
>ITEM_ID
>) ON PRIMARY,
>CONSTRAINT FK_BBSItem_BBSItem1 FOREIGN KEY
>(
>LATEST_REPLICATION_ID
>)REFERENCES BBSItems(
>ITEM_ID),
>CONSTRAINT FK_BBSItem_UserInfo FOREIGN KEY
>(
>AUTHOR
>)REFERENCES userinfo(nickname)
>)
>ON PRIMARY
>GO
>
>wrong in row 20 nearPRIMARY
Navigation:
[Reply to this message]
|