I want to get the new created ID when you insert a new record in table.

I read this: <http://msdn.microsoft.com/en-us/library/ms177564.aspx> but it needs to create temporary table.

I want to return the ID after executing INSERT statement (assuming executing just one INSERT).

Example: 

```
1     Joe      Joe
2     Michael  Mike
3     Zoe      Zoe

```

When executing an INSERT statement, I want to return the created ID, means 4.

Can tell me how to do that using SQL statement or it is not possible ?