sql server identity value after insert in stored procedure

Jak

Member

858 Points

132 Posts

Views: 9194
Total Answered: 1
Total Marked As Answer: 1
Posted On: 04-May-2015 05:16

Share:

Answers

Rahul M...

Teacher

4822 Points

23 Posts

Hi,
Suppose I have a table with IDENTITY(1,1) as:

CREATE TABLE [dbo].[tablename](

[IdentityColumm] [bigint] IDENTITY(1,1) NOT NULL,

)

In Storred procedure we can get identiry value as:

INSERT INTO tablename(...)

VALUES(...)

SET @IdentityValue=ISNULL(SCOPE_IDENTITY(),0)

Posted On: 03-May-2015 16:56

Discussion

MVC Design pattern