Manish Vij Manish Vij - 6 months ago 23
SQL Question

SQL server: difference between DELETE <Table> and DELETE from <Table>

SQL server:

Difference between :

Delete tblxyz where id=6

and :

Delete from tblxyz where id=6

Is their any difference between above queries ?


enter image description hereThere is no difference if you see the execution plan both generates delete scripts as below

DELETE [testtable]  WHERE [numbers]=@1