title: Inserting rows into a table with one IDENTITY column only
body: <p>I have a table Administrator with only one column, adminId which is the primary-key. Because of business rules it has to be this way. </p>
  
  <p>I'd like to understand once and for all how I can write stored procedures that insert values in tables like this. I am using SQL Server and T-SQL and tried using SCOPE_IDENTITY() but that doesn't work since the table has INSERT_IDENTITY to false or off.</p>
  
  <p>I'd really like to not insert a dummy value just to be able to insert a new row.   Thanks!</p>