How to insert into a table with just one IDENTITY column?

by

This should work:

INSERT INTO GroupTable DEFAULT VALUES

More Related Contents:

  1. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  2. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  3. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  4. SQL server identity column values start at 0 instead of 1
  5. Get the mentioned output by SQL query
  6. Sql Mathematical calculations [closed]
  7. I need help formatting inner join command in SQL query
  8. How to deal with SQL column names that look like SQL keywords?
  9. SQL transpose full table
  10. Truncate (not round) decimal places in SQL Server
  11. How to Create a real one-to-one relationship in SQL Server
  12. Select statement to find duplicates on certain fields
  13. Getting only Month and Year from SQL DATE
  14. Is it possible to select sql server data using column ordinal position
  15. Does MS SQL Server’s “between” include the range boundaries?
  16. Check for file exists or not in sql server?
  17. Dynamic SQL to generate column names?
  18. SQL Server PIVOT perhaps?
  19. How to find consecutive rows based on the value of a column?
  20. Merge row values into a CSV (a.k.a GROUP_CONCAT for SQL Server)
  21. Which SQL query is faster? Filter on Join criteria or Where clause?
  22. Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’
  23. SQL Server *= Operator?
  24. Difference between “read commited” and “repeatable read” in SQL Server
  25. Slow bulk insert for table with many indexes
  26. operation not allowed when the object is closed when running more advanced query
  27. is it possible to select EXISTS directly as a bit?
  28. Using CASE Statement inside IN Clause
  29. SQL Convert Week Number to Date (dd/MM)
  30. SQL Unpivot multiple columns Data

Leave a Comment