Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?

by

Your syntax almost works in SQL Server 2008 (but not in SQL Server 20051):

CREATE TABLE MyTable (id int, name char(10));

INSERT INTO MyTable (id, name) VALUES (1, 'Bob'), (2, 'Peter'), (3, 'Joe');

SELECT * FROM MyTable;

id |  name
---+---------
1  |  Bob       
2  |  Peter     
3  |  Joe

1 When the question was answered, it was not made evident that the question was referring to SQL Server 2005. I am leaving this answer here, since I believe it is still relevant.

More Related Contents:

  1. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  2. Check if table exists in SQL Server
  3. Sql Server string to date conversion
  4. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  5. Parameter Sniffing (or Spoofing) in SQL Server
  6. How to get Time from DateTime format in SQL?
  7. SQL Server String or binary data would be truncated
  8. Datatype for storing ip address in SQL Server
  9. How to change identity column values programmatically?
  10. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  11. How much size “Null” value takes in SQL Server
  12. best way to convert and validate a date string
  13. SQL Server ORDER BY date and nulls last
  14. How to remove accents and all chars a..z in sql-server?
  15. Find non-ASCII characters in varchar columns using SQL Server
  16. WHERE clause on SQL Server “Text” data type
  17. SQL Server error on update command – “A severe error occurred on the current command”
  18. Aggregate bitwise-OR in a subquery
  19. SQL server schema and default schema
  20. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  21. FOR XML PATH(”): Escaping “special” characters
  22. SELECT INTO a table variable in T-SQL
  23. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  24. Does query plan optimizer works well with joined/filtered table-valued functions?
  25. What are row, page and table locks? And when they are acquired?
  26. @@ERROR and/or TRY – CATCH
  27. SQL Server query to find all permissions/access for all users in a database
  28. Pass Dictionary to Stored Procedure T-SQL
  29. How can I do something like: USE @databaseName
  30. How to query values from xml nodes?

Leave a Comment