Manish Vij Manish Vij - 1 year ago 77
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 Source

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

DELETE [testtable]  WHERE [numbers]=@1
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download