SQL server:
Difference between :
Delete tblxyz where id=6
and :
Delete from tblxyz where id=6
Is their any difference between above queries ?
There is no difference if you see the execution plan both generates delete scripts as below
DELETE [testtable] WHERE [numbers]=@1
There is no direct difference between the two statements (except that I find the "DELETE FROM" easier to read and understand)
note that ANSI does require the "FROM" keyword as stated by jarlh
see also https://msdn.microsoft.com/en-us/library/ms189835.aspx
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With