|
18>
19> -- Identity
20>
23> CREATE TABLE MyTable (MyID Int IDENTITY(1, 1) NOT NULL
24> , MyDescription nVarChar(50) NOT NULL)
25>
26> insert mytable (mydescription) values ('a');
27> insert mytable (mydescription) values ('b');
28> insert mytable (mydescription) values ('c');
29>
30> select * from mytable
31> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
MyID MyDescription
----------- --------------------------------------------------
1 a
2 b
3 c
(3 rows affected)
1>
2> drop table MyTable
3> GO
1>
|