关于sql面试题答:建议写个存储过程吧 假设表名为cj create proc fs as declare @temp table (id int,name varchar(10),score int,tpid int identity(1,1),kemu varchar(10))begin insert into @temp(id,name,score,kemu)select id,name,score,'dd' from cj update @temp set kemu='yw' where tpid%3=1 ...