SQL操作总结

彻底删除test表，不在日志工进行记录
truncate table test

在日志中进行记录
delete from test  //删除整个表
delete from test where id = (select id from test1 where name='好的')  //根据筛选出的条件删除记录
delete test from (select top 100 * from test) as test1 where test.id = test1.id  //删除test表中的前100条记录

1、更新一条记录的值
update test set name="汤汤" where id='11'
2、更新多个记录的值
update test set wage = wage +100
update test set wage = wage*(1+5%) where id='11'
3、带子查询的更新语句
update employee set employee.dept_id (select dept_id from department where dep_name='信息部')