How to fix parse error which I get like this?

Question

How to fix parse error which I get like this?

Keerthana J 71

I am getting error like 
ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Parse error at line: 14, column: 33: Incorrect syntax near 'ID'.

My schema is
create TABLE [dbo].[op]

(

	[P ID] [int] NULL,
	[col1] [varchar](700) NULL,
	[ID] [bigint] NULL,
	[Col2] [varchar](700) NULL,
	[Col3] [int] NULL,
	[col4] [varchar](700) NULL,
	[Col5] [varchar](700) NULL,
	[Col6] [varchar](700) NULL,
	[Col7] [varchar](700) NULL,
	[Col8] [varchar](700) NULL,
	[event_timestamp] [datetime2](7) NULL

)

WITH

(

	DISTRIBUTION = ROUND_ROBIN,
	CLUSTERED INDEX

	(

		[P ID] ASC

	)

)

GO

But i dont see any issues here.

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-02-27T22:52:42.9533333+00:00

Hi @Anonymous ,

Welcome to Microsoft Q&A forum and thanks for reaching out here.

Could you please confirm are you trying to create the table in Synapse Analytics Dedicate SQL pool? or Azure SQL server? Or some other server?

If Synapse Analytics dedicated SQL pool, then please confirm if the Dedicated SQL server is created from Synapse Studio or it was old Azure SQL Datawarehouse?

I tried to run the query you shared above in Synapse Analytics Dedicated SQL (created from Azure Synapse Analytics Studio) and was able to create a table without errors. Please see below:

Thanks
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-03-01T00:03:15.17+00:00

@Anonymous Following up to see if you have got a chance to see my previous repsonse. If so, could you please confirm the requested details.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-03-01T23:09:16.3633333+00:00

@Anonymous We still have not heard back from you. Just wanted to check if you are still blocked and need assistance on this query. If so, please share few additional details as requested. In case if you have already found a solution, kindly consider sharing your findings here as it would help others reading this thread.

Thank you

1 answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-02-27T22:52:42.9533333+00:00

Hi @Anonymous ,

Welcome to Microsoft Q&A forum and thanks for reaching out here.

Could you please confirm are you trying to create the table in Synapse Analytics Dedicate SQL pool? or Azure SQL server? Or some other server?

If Synapse Analytics dedicated SQL pool, then please confirm if the Dedicated SQL server is created from Synapse Studio or it was old Azure SQL Datawarehouse?

I tried to run the query you shared above in Synapse Analytics Dedicated SQL (created from Azure Synapse Analytics Studio) and was able to create a table without errors. Please see below:

Thanks
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-03-01T00:03:15.17+00:00

@Anonymous Following up to see if you have got a chance to see my previous repsonse. If so, could you please confirm the requested details.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-03-01T23:09:16.3633333+00:00

@Anonymous We still have not heard back from you. Just wanted to check if you are still blocked and need assistance on this query. If so, please share few additional details as requested. In case if you have already found a solution, kindly consider sharing your findings here as it would help others reading this thread.

Thank you

Answer 1

Vinodh247 34,661 MVP Volunteer Moderator

Hi

Thanks for reaching out to Microsoft Q&A.

Error says its a syntax error.

Change [P ID] as [P_ID] and try executing the query. Let me know if this worked.

Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

Share via

How to fix parse error which I get like this?

1 answer

Your answer