TIPS: SQLexecutionloop

During the test, we usually need to execute many identical statements consecutively. I used to do this through the While LOOP, but there is a simpler method, you only need to use Go to implement it. The Code is as follows: usedbagcreatetabletest (namevarchar (10) on [group] goinsertintotestvalues (all

During the test, we usually need to execute many identical statements consecutively. I used to do this through the While LOOP, but there is a simpler method, you only need to use Go to implement it. The Code is as follows: use DBA go create table test (name varchar (10) on [group] go insert into test values ('all

During the test, we usually need to execute many identical statements consecutively. I used to do this through the While LOOP, but there is a simpler method, you only need to use Go to implement it.

The Code is as follows:

Use DBA

Go

Create table test (namevarchar (10) on [group]

Go

Insert into testvalues ('allen ')

Go 1, 1000

Display result:

Beginning execution loop

(1 row (s) affected)

(1 row (s) affected)

(1 row (s) affected)

(1 row (s) affected)

.........

The last step is to verify that the data has been saved to the table.