[sql-server] How can INSERT INTO a table 300 times within a loop in SQL?

DECLARE @first AS INT = 1
DECLARE @last AS INT = 300

WHILE(@first <= @last)
BEGIN
    INSERT INTO tblFoo VALUES(@first)
    SET @first += 1
END

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to tsql

• Passing multiple values for same variable in stored procedure • Count the Number of Tables in a SQL Server Database • Change Date Format(DD/MM/YYYY) in SQL SELECT Statement • Stored procedure with default parameters • Format number as percent in MS SQL Server • EXEC sp_executesql with multiple parameters • SQL Server after update trigger • How to compare datetime with only date in SQL Server • Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot • Printing integer variable and string on same line in SQL

Examples related to loops

• How to increment a letter N times per iteration and store in an array? • Angular 2 Cannot find control with unspecified name attribute on formArrays • What is the difference between i = i + 1 and i += 1 in a 'for' loop? • Prime numbers between 1 to 100 in C Programming Language • Python Loop: List Index Out of Range • JavaScript: Difference between .forEach() and .map() • Why does using from __future__ import print_function breaks Python2-style print? • Creating an array from a text file in Bash • Iterate through dictionary values? • C# Wait until condition is true

Examples related to insert

• How to insert current datetime in postgresql insert query • How to add element in Python to the end of list using list.insert? • Python pandas insert list into a cell • Field 'id' doesn't have a default value? • Insert a row to pandas dataframe • Insert at first position of a list in Python • How can INSERT INTO a table 300 times within a loop in SQL? • How to refresh or show immediately in datagridview after inserting? • Insert node at a certain position in a linked list C++ • select from one table, insert into another table oracle sql query