Syntax error

• komal145

  SSCrazy Eights

  Points: 9920

  More actions

  May 15, 2017 at 9:15 am

  #342851

  hi ..Can anyone tell me what is the error here. I tried closing the table and adding but it still give errors

  CREATE TABLE [Comp].[Model](
    [Model] [nvarchar](255) NOT NULL,
      [ModelCondition] [nvarchar](100) NULL )
  WITH (DATA_COMPRESSION = PAGE) ON [Comp]

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  May 15, 2017 at 9:22 am

  #1942583

  komal145 - Monday, May 15, 2017 9:15 AM

  .Can anyone tell me what is the error here.

  SQL Server probably can.  What is the error message?

  John

• debasis.yours

  Hall of Fame

  Points: 3528

  More actions

  May 15, 2017 at 9:22 am

  #1942585

  Hi Komal,

  Please try putting the ON clause before WITH clause. So it might look like
  CREATE TABLE [Comp].[Model](
  [Model] [nvarchar](255) NOT NULL,
    [ModelCondition] [nvarchar](100) NULL ) ON [Comp]
  WITH (DATA_COMPRESSION = PAGE)          

  Please check and let us know.

  Thanks.

• komal145

  SSCrazy Eights

  Points: 9920

  More actions

  May 15, 2017 at 9:25 am

  #1942586

  thank you it works.

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  May 15, 2017 at 9:25 am

  #1942587

  komal145 - Monday, May 15, 2017 9:15 AM

  hi ..Can anyone tell me what is the error here. I tried closing the table and adding but it still give errors

  CREATE TABLE [Comp].[Model](
    [Model] [nvarchar](255) NOT NULL,
      [ModelCondition] [nvarchar](100) NULL )
  WITH (DATA_COMPRESSION = PAGE) ON [Comp]

  You have the clauses inverted.
  
CREATE TABLE [Comp].[Model](
[Model] [nvarchar](255) NOT NULL,
[ModelCondition] [nvarchar](100) NULL )
ON [Comp] WITH (DATA_COMPRESSION = PAGE)


  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2