Insert Statement And Return Identity

INSERT SomeTable

(

  @SomeColumn1,

  @SomeColumn2

)

VALUES

(

  @SomeParameter1,

  @SomeParameter2

)

SELECT IDENT_CURRENT(‘SomeTable’)

Advertisements