Shulou(Shulou.com)05/31 Report--

What is the method of batch execution of sql statements, many novices are not very clear about this, in order to help you solve this problem, the following small series will explain in detail for everyone, there are people who need this to learn, I hope you can gain something.

The code is as follows: DECLARE @MyCounter INT SET @MyCounter = 0 /* Set variable */ WHILE (@MyCounter < 2) /* Set number of cycles */ BEGIN WAITFOR DELAY '000:00: 1'/* Delay time 1 second */ INSERT INTO comments (username) values ('ahuinan') SET @MyCounter = @MyCounter + 1 END

Did reading the above help you? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.