SQL???????????????????????
???????????? ???????[ 2015/8/17 11:14:39 ] ?????????????
????????????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;
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11