[Cialug] SQL Question: Advanced INSERT INTO

[L. V. Lammert]

On Fri, 3 Sep 2010, Todd Walton wrote:

> Dear Techie Friends and other SQL Knowledgeable,
>
> I'm wondering, if I need to do an INSERT INTO a table, and the table
> has a counter for a primary key, how do I handle setting the counter?
>
It looks like you want an ID field, .. in which case, you would be far
better off using an auto-increment data type and let the database handle
it for you.

	Lee