从表中删除和从表中删除*之间的差异 [英] Diff between Delete from table and delete * from table

问题描述

任何人都可以解释原因

从表中删除表与删除*从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) ^_^

这篇关于从表中删除和从表中删除*之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！