1> CREATE TABLE MyTable (MyID Int IDENTITY NOT NULL
2> , MyDescription nVarChar(50) NOT NULL)
3> GO
1>
2> -- IDENTITY [ (seed , increment ) ]
3>
4> insert mytable (mydescription) values ('a');
5> GO
(1 rows affected)
1> insert mytable (mydescription) values ('b');
2> GO
(1 rows affected)
1> insert mytable (mydescription) values ('c');
2> GO
(1 rows affected)
1> select * from mytable
2> GO
MyID MyDescription
----------- --------------------------------------------------
1 a
2 b
3 c
(3 rows affected)
1>
2> drop table MyTable
3> GO
1>