/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [StudentNo]
,[kemu]
,[Score]
,[time]
FROM [MySchool].[dbo].[Table_2]
update table_2 set score=score+5 where kemu=1 and time<='2013-9-13' and score<60
测试
最新推荐文章于 2023-06-02 21:06:00 发布