删除表记录(delete from ....where)

delete from [dbo].[userinfo]
where ID=2;
delete from [dbo].[userinfo]
where ID=3 or ID=4;--删除多行  满足条件就删除

delete from [dbo].[userinfo]
where ID in(6,7);--删除多行 删除6和7

 

版权声明：本文为Wchenchen0原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。