92

使用T-SQL语句操作数据表-删除数据-计刚-51CTO博客

 6 years ago
source link: http://blog.51cto.com/13588598/2066335
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
1.使用delete语句删除表中的数据:语法:deletefrom<表名>[where<删除条件>]delete是删除的意思where是选填内容可以不加,但是不加条件的话是删除整个表例子:deletefrom成绩表where姓名='张三'含义:删除成绩表中张三的信息,如果不加where就是删除整个成绩表注意:delete用于删除整条记录,不会删除单个字段,也

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK