Need to load a lot of test data? GO [n]

Happy Friday! Here’s a simple trick I love using in SQL Server Management Studio (SSMS).

I’m all about the demos today. Let’s jump into SSMS.

CREATE TABLE Test (ColumnA varchar(10))
GO

And now we insert some data.

INSERT INTO Test
SELECT 'Data'
GO 10

It’s really as simple as that. Hopefully this saves some wear and tear on your F5 key.