Currently upgrading from Access to MS SQL in classic ASP applications. I have one app that deletes the contents of a table before repopulating the table. It worked fine in Access but is erroring out with the MS SQL Database.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near '*'.
/sql_test/index.asp, line 14
theSQL = "delete * from u_id"
set theSQL = Nothing