SQL Server – Insert same value multiple time in SQL table

 

Here is an example:  Inserting same value multiple time in SQL table

USE testdb
GO

CREATE TABLE table1
(
	id INT IDENTITY(1,1),
	name VARCHAR(255),
	address VARCHAR(255)
)

SELECT * FROM testdb..table1

INSERT INTO testdb..table1 VALUES ('Varinder','ABC Street')
go 5

Result :