SQL syntax

[omar_ismail]

I am getting the below error anyone can elaborate?

Bulk insert: Deferred prepare could not be completed.
Statement(s) could not be prepared.
Incorrect syntax near ‘date’.
Incorrect syntax near ‘date’.

[Palaniyappan (Forum Leader)]

Hi

This means that there is a problem with the way that the date is being used in the SQL statement.

To fix this error, you need to check the SQL statement and make sure that the date is being used correctly. The date should be enclosed in single quotes (')

Like

SELECT * FROM table WHERE date = ‘2023-09-12’

Refer this thread for some insights if u r using variable

Update sql table with date format include

Dear members, I have a sql table, which include date type, need to update date from excel to the sql table, not sure which type I could set for the Parameters? I can only get datetime type variable, not sure how to get date type variable. Thanks.

Cheers @omar_ismail

[omar_ismail]

so you mean that i should rename the date column in the SQL table to be ‘date’? please correct me if I am wrong

[Palaniyappan (Forum Leader)]

No you need pass the value with single quotes
@omar_ismail