Ensure a SQL Table Has a Certain Number of Rows

Here is a useful simple script that can be modified to ensure a table has a certain number of rows. The example uses an insert statement, however I have used it to call a stored procedure that inserts rows (among other things). It is easier than copy/pasting insert/stored procedure statements.

?

Source:

1 2 3 4 5 6 7 8 9

DECLARE @Count as int SELECT @Count = COUNT(DemoItemID) FROM DemoItems WHILE @Count < 50 BEGIN  INSERT INTO DemoItems ([DemoItemID])   VALUES (@Count+1)  SELECT @Count = COUNT(DemoItemID) FROM DemoItems END PRINT 'Done.'