????????????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;