从表中删除和从表中删除*之间的差异

本文介绍了从表中删除和从表中删除*之间的差异的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

任何人都可以解释原因 从表中删除表与删除*从sql server中的表之间的区别 先谢谢

解决方案

没有^ _ ^ 在旧版本中，只使用了表格中的delete *，但是从表格中删除（不是所有内容）毫无意义他们介绍了删除表。他们保留了旧的语法，以免破坏任何旧的脚本。 FYI：从表中删除也是有效的（和首选语法）^ _ ^

Can any one explain the reason Difference between delete from Table and Delete * from table in sql server Thanks in Advance

解决方案

There is none ^_^ In older versions only delete * from table was used, but as delete (not everything) from table made no sense they introduced delete table. They kept the old syntaxt so as not to break any older scripts. FYI: Delete From table is also valid (and the preferred syntax) ^_^