Use Tempdb;GOCREATE 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;
DELETE FROM demodelete x WHERE x.somenum = 1;DELETE <missing required source>FROM demodelete xWHERE x.somenum = 1;DELETE FROM demodelete<missing required FROM> <missing required object> xWHERE x.somenum = 1;
DELETE FROM xFROM demodelete xWHERE x.somenum = 1;