07-31-2023, 05:44 AM
In SQL Server Compact Edition in Visual Studio 2010 (maybe SQL Server and SQL in general, I don't know), this command works:
DELETE FROM foods WHERE (name IN ('chickens', 'rabbits'))
but this command produces an error of: `Error near identifier f. Expecting OUTPUT.`
DELETE FROM foods f WHERE (f.name IN ('chickens', 'rabbits'))
DELETE FROM foods WHERE (name IN ('chickens', 'rabbits'))
but this command produces an error of: `Error near identifier f. Expecting OUTPUT.`
DELETE FROM foods f WHERE (f.name IN ('chickens', 'rabbits'))