Manish Vij Manish Vij - 2 months ago 8
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 ?

Answer

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

DELETE [testtable]  WHERE [numbers]=@1