Home Forums SQL Server 7,2000 T-SQL new year new number Generating in SQL server RE: new year new number Generating in SQL server

  • problem with the code

    ----------------------------------

    CREATE TABLE [tblTest] (

     [YEARVAL] [smallint] NOT NULL CONSTRAINT [DF_tblXXX_YEARVAL] DEFAULT (datepart(year,getdate())),

     [AUTONUM] [int] IDENTITY (1, 1) NOT NULL ,

     [ValX] [char] (1) NOT NULL ,

     CONSTRAINT [PK_tblTest] PRIMARY KEY  CLUSTERED

     (

      [YEARVAL],

      [AUTONUM]

       ON [PRIMARY]

    ) ON [PRIMARY]

    GO

    ----------------------------------

    the error

    Server: Msg 156, Level 15, State 1, Line 9

    Incorrect syntax near the keyword 'ON'.