Hello,
Thanks for the response. However, I still have two questions:
1. Why is the X necessary after the DELETE key word? Wouldn't DELETE FROM demodelete x WHERE x.somenum = 1; work? If not, why?
2. What is wrong with the usage of the alias x in the query attached to the original message?
Thanks again!
Gabor
SQLRNNR (1/16/2013)
Here is a script demonstrating a delete using an alias as well as using the alias X
Use Tempdb;
GO
CREATE TABLE demodelete (somenum INT);
INSERT INTO demodelete (somenum)
VALUES (1),(2),(3),(4);
SELECT * FROM demodelete;
DELETE X
FROM demodelete x
WHERE x.somenum = 1;
SELECT *
FROM demodelete;