Shulou(Shulou.com)06/01 Report--

To achieve the effect of statement loop through the GO command is also called batch loop

Print 'output 10 times' GO 10

It can also be used to add statements.

NOCOUNT ON is used to mask the number of lines affected by the output of new statements. We only look at the number of loops.

SET NOCOUNT ON;GOINSERT INTO dbo.T1 DEFAULT VALUES;GO 100

Summary

The above is the SqlServer GO command recycle example code introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply you in time. Thank you very much for your support to the website!

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.