• seems to be a good article

    but

    is this query correct

    CREATE TABLE [tblCpls] (

    [cplNum] [int] NULL ,

    [cplName] [varchar] (4000) NULL ,

    [cplDesc] [varchar] (1000) NULL,

    CONSTRAINT [PK_tblList] PRIMARY KEY CLUSTERED

    (

    [cplnum]

    ) ON [PRIMARY]

    )

    ) ON [PRIMARY]

    GO

    how can u create a Clustered index on nullable column ??




    My Blog: http://dineshasanka.spaces.live.com/