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

Posted in Uncategorized | Tagged | Leave a comment