In the ASP program, you want to add a new field in the data table through the ASP. According to "SQL Chinese Reference Manual.", "ALTER TABLE Employees Alter Column Salary Char (20)" statement, actually 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 all the findings, there is no result, only the reasons for SQL70 and SQL65 are mentioned, and do not understand.
Finally found the answer in the SQL Server online series, it turned out to be "column", which may be because the SQL version is different, the statement rules are different.
Change to "Alter Table Employees ALTER SALY CHAR (20)".
Thus, a lesson is obtained: You cannot use the "SQL Chinese Reference Manual .CHM", you have to use your own SQL Server online from the book.
