T-SQL 查询、修改数据表

*/ 14 UPDATE student 15 SET sname='张三十',sage=sage-2 --同时更新多列 16 WHERE sno=1 17 18 select * from student ------------------------------------------ 20 21 /*使用top表达式*/ 22 UPDATE top(2) student 23 SET sage=sage -2 24 25 UPDATE top(50) percent student 26 SET sage=sage-2 DELETE语句 语法： DELETE table_name