i have two table (table1,table2)

```
table1 - table1_seq PK identity(1,1),
         table1_descpt

table2 - table2_seq PK identity(1,1),
         table1_seq foreign key of table1,
         table2_descpt 

```

i want `table1_seq` same time when `insert into table1(table1_desc) values ('Description');` 

**like** `select table1_seq from (insert into table1(table1_desc) values ('Description'));`

so i can insert `table1_seq` into table2