Retrieving the Maximum Value of key_col from MyTable : Identity « Sequence Indentity « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Sequence Indentity
3. Identity

5> CREATE TABLE MyTable (
6>  key_col int NOT NULL IDENTITY (1,1),
7>  abc     char(1) NOT NULL
8> )
9> INSERT INTO MyTable VALUES ('a')
10> INSERT INTO MyTable VALUES ('b')
11> INSERT INTO MyTable VALUES ('c')
12> SELECT * FROM MyTable ORDER BY key_col
13>
14>
15> SELECT
16>  MAX (key_col) AS max_key_col
17> FROM
18>  MyTable
19>
20> drop table MyTable
21> GO

(1 rows affected)

(1 rows affected)

(1 rows affected)
key_col     abc
----------- ---
          1 a
          2 b
          3 c

(3 rows affected)
max_key_col
-----------
          3

(1 rows affected)
1>