how to insert into a table that the only column is an identity field?

how to insert into a table that the only column is an identity field?

 

  

Hi list,

I have a table called EmailGroup and the only column in that table is EmailGroupID which is defined as an identity field. How can I insert a record to that table?

Obviously, I don't want to set identity_insert table_name ON since I want the system to generate the identity column value for me.

Any idea?

Thanks and have a good 4th of July!

Elaine








MS Sql Server LazyDBA home page