Can't ask T-SQL question

Question

Can't ask T-SQL question

Mark McCumber 436

I have a SQL that I can't debug. However I can't post it. Why?

Thanks,
MRM256

Yitzhak Khabinsky 27,196 Reputation points

2022-08-16T14:37:53.81+00:00

Bugs, bugs, bugs.
Even here, on the Microsoft Q&A forum.
Viorel 127K Reputation points

2022-08-16T16:40:51.447+00:00

Try attaching a text file with your query. If the query is not large, you can also insert an image.
Mark McCumber 436 Reputation points

2022-08-16T19:45:48.787+00:00

Can you tell me why this won't work?

CREATE TABLE tblStates ON [PRIMARY]
GO

The parser in SSMS gives me these errors:
Msg 156, Level 15, State 1, Line 68
Incorrect syntax near the keyword 'IDENTITY'.
Msg 319, Level 15, State 1, Line 78
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

Completion time: 2022-08-16T14:25:43.0647834-05:00

Answer accepted by question author

Tom Cooper 8,501

There are several errors in what you posted. The following should work

CREATE TABLE [tblStates](  
[StateID] [int] NOT NULL IDENTITY,  
[State] [varchar](30) NOT NULL,  
[StateAbbrv] varchar(2) NOT NULL,  
CONSTRAINT PK_tblStates PRIMARY KEY CLUSTERED  
(  
 StateID  
)  
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  
) ON [PRIMARY]  
GO

Tom

Mark McCumber 436 Reputation points

2022-08-16T20:09:40.657+00:00

Yes, there were.

1 additional answer

Your answer

Yitzhak Khabinsky 27,196 Reputation points

2022-08-16T14:37:53.81+00:00

Bugs, bugs, bugs.
Even here, on the Microsoft Q&A forum.
Viorel 127K Reputation points

2022-08-16T16:40:51.447+00:00

Try attaching a text file with your query. If the query is not large, you can also insert an image.
Mark McCumber 436 Reputation points

2022-08-16T19:45:48.787+00:00

Can you tell me why this won't work?

CREATE TABLE tblStates ON [PRIMARY]
GO

The parser in SSMS gives me these errors:
Msg 156, Level 15, State 1, Line 68
Incorrect syntax near the keyword 'IDENTITY'.
Msg 319, Level 15, State 1, Line 78
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

Completion time: 2022-08-16T14:25:43.0647834-05:00
Mark McCumber 436 Reputation points

2022-08-16T20:09:40.657+00:00

Yes, there were.

Answer 1

Mark McCumber 436

Can't post SQL to this site.

0 comments

Share via

Can't ask T-SQL question

1 additional answer

Your answer