In SQL-Server :
1) How can I get the current identity number of a table after I insert a
record (if the primary key is identity) ?
2) What SQL-command is for changing the Identity current number (so, if I
insert another record, I'll start with another sequence number) ?