-
Recent Posts
Recent Comments
- Statistics (Part 8) – Nulls | Dale Burnett on Statistics (Part 2) – I am your density
- Statistics (Part 8) – Nulls | Dale Burnett on Statistics (Part 7) – Magic Density
- Aaron Bertrand on Column Aliases (or Who Is That Masked Crusader?)
- Michael J Swart on The Value of Expertise (or Are You Sure About That?)
- Michael J Swart on Anatomy of a hack (SQL Injection woes)
Archives
Categories
Meta
Blogroll
Monthly Archives: June 2011
Execute a batch multiple times
Occasionally I need to create sample data but am not concerned about the selectivity of the data. Rather than using a WHILE loop I use the count argument of the GO command. INSERT INTO Test (Col1,Col2) VALUES (’ABC’,'DEF’) GO 1000 … Continue reading
