"There is a syntax error near the keyword ' COLUMN '. "What's going on?" It's actually very simple!

In an ASP program, you want to add a new field to the datasheet by using ASP, and the statement "ALTER TABLE Employees alter COLUMN Salary CHAR (20)" is used, as described in the SQL Chinese reference Manual. CHM, to make an error:

Microsoft OLE DB Provider for SQL Server error ' 80040e14 '

There is a syntax error near the keyword ' COLUMN '.

/ddd/ttt.asp, line 22

On the internet and everywhere to find the reason, no results, only mentioned SQL70 and SQL65 reasons, do not understand.

Finally found the answer in SQL Server Books Online, which is more "COLUMN", probably because the SQL version is different, the statement rules are different.

Change to "Alter TABLE Employees ALTER Salary CHAR (20)".

Thus, there is a lesson: You cannot use the "SQL Chinese reference Manual. Chm", to use your own installed SQL Server online from the book for reference.