DECLARE @RowCount int
DECLARE @Random int

SET @RowCount = 0

WHILE @RowCount < 100
BEGIN
  SELECT @Random = ROUND((10 * RAND()), 0)

  INSERT INTO dbo.Sample_Table (column_1, column_2)
    VALUES
    (
        @RowCount,
        REPLICATE('lorem lipsum', @Random)
    )

  SET @RowCount = @RowCount + 1
END
GO