Using GO Repeat To Fill Tally Table

jhogg-761895, 2010-08-18 (first published: 2010-08-16)

This script can be used to fill a primary key column quickly without using a traditional loop or cursor. The interesting part is the "GO n" section which will repeat code within the batch "n" number of times. Be sure to create the TinyTally table first.

-- tally table used for parsing smallish columns dbo.TinyTally(N tinyint IDENTITY PRIMARY KEY); SET IDENTITY_INSERT dbo.TinyTally ON; GO -- Prime the table first INSERT dbo.TinyTally(N) VALUES(IDENT_CURRENT('dbo.TinyTally')); GO INSERT dbo.TinyTally(N) VALUES(IDENT_CURRENT('dbo.TinyTally')+1); GO 254 -- Really cool tidbit I picked up from SQL Saturday #40 (will now repeat batch 254 times!) SET IDENTITY_INSERT dbo.TinyTally OFF; GO SELECT * FROM dbo.TinyTally; GO

Go Unit Tests: Tips from the Trenches

by Additional Articles

SimpleTalk

In this article, Michael Sorens describes unit testing for applications written in Go. While focused on Go, many of his recommendations and techniques can be applied to other languages as well.

2018-08-13

2,707 reads