This query works fine with MS Access db, but gives me error with SQL Server 7.
'
"DELETE * FROM tbMyTable"
'
I try to delete all records from the table.
Why it doesn't work with SQL Server?
Printable View
This query works fine with MS Access db, but gives me error with SQL Server 7.
'
"DELETE * FROM tbMyTable"
'
I try to delete all records from the table.
Why it doesn't work with SQL Server?
In Sql Server just give
"Delete from <tablename>"
instead of "delete * ...."
I guess that is the difference.