Why can't I use an alias in a DELETE statement?

SqlSql ServerSql Server-Ce

Sql Problem Overview

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'))

Sql Solutions

Solution 1 - Sql

To alias the table you'd have to say:

DELETE f FROM dbo.foods AS f WHERE f.name IN (...);

I fail to see the point of aliasing for this specific DELETE statement, especially since (at least IIRC) this no longer conforms to strict ANSI. But yes, as comments suggest, it may be necessary for other query forms (eg correlation).

Solution 2 - Sql

The delete statement has strange syntax. It goes like this:

DELETE f FROM foods f WHERE (f.name IN ('chickens', 'rabbits'))
Categories
Recommended Sql Solutions
Recommended Sql Server Solutions
Recommended Sql Server-Ce Solutions

Previous Solution:

How to convert a table to a data frame

RDataframe

Next Solution:

How to get current foreground activity context in android?

AndroidAndroid Activity

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionRicardo AltamiranoView Question on Stackoverflow
Solution 1 - SqlAaron BertrandView Answer on Stackoverflow
Solution 2 - SqlusrView Answer on Stackoverflow