????????????SQL?校????????????????????????????????????????????????????F5???????????????????????????????????????10????????小??????????????????????貌??SQL???????贸????????渭???????????????????????????????????写??????????????????????????????????????????校?????????写?????????????????????小?
????????
????1 USE AdventureWorks2008R2
????2 GO
????3
????4 WHILE 1=1
????5 BEGIN
????6     SELECT COUNT(*) FROM HumanResources.Employee
????7     WAITFOR DELAY '00:00:01'
????8 END
??????泻?????????SSMS????蟹?????????????????????????????????????1-2???????????“??”???????????????????????????????效????写??????????????????X??????????????????????-_-!!?????????????写??????械???????????????
?????????????锟�?
????1 WHILE 1=1
????2 BEGIN
????3     SELECT * FROM HumanResources.Employee
????4     WAITFOR DELAY '00:00:01'
????5 END
????????????????????????SSMS?????????????????????????????????小??SSMS??????????危???????????????????????????????????????
???????????????????????????????????????????????????????锟�????????????????????????????????
???????????锟�?
????1 WHILE 1=1
????2 BEGIN
????3     SELECT COUNT(*) FROM HumanResources.Employee
????4     PRINT REPLICATE(1??4000)
????5     WAITFOR DELAY '00:00:01'
????6 END
???????????????????????????????尾??????????????PRINT REPLICATE(1??4000)??4000????1000????????????????????????薪????????2000???????校???????校?????3000????械?????????4000??????????贸?????????????4000????????SSMS????????
??????????渭???????????????SELECT???????????校?????邪??????渭??????????????????????????????
??????????????????锟�?
1 SET NOCOUNT ON;
2
3 WHILE 1=1
4 BEGIN
5     SELECT 'The count at ' + CONVERT(VARCHAR(20)??GETDATE()??20) + ' is ==> ' + RTRIM(COUNT(*)) FROM HumanResources.Employee
6     PRINT REPLICATE(' '??4000)
7     WAITFOR DELAY '00:00:01'
8 END
9
10 SET NOCOUNT OFF;