return Identity in SQLServer Compact

Question

How do you get the identity column value after an insert in SQL Server Compact 3.5?

score 4 · Accepted Answer · answered Jul 29 '09 at 21:34

4

I think what you want is @@IDENTITY:

SELECT @@IDENTITY AS Identity

This will return the value of the last identity inserted.

answered Jul 29 '09 at 21:34

Matthew Jones

I didn't think SSCE supports sql batch statements, will have to check – Kumar Jul 30 '09 at 04:11

score 1 · Answer 2 · answered Jul 29 '09 at 21:33

1

I guess you have to use @@IDENTITY. I figured compact would have SCOPE_IDENTITY(), but I guess not. Just try scope_identity to be sure. :)

answered Jul 29 '09 at 21:33

JP Alioto

I didn't think SSCE supports sql batch statements, will have to check – Kumar Jul 30 '09 at 04:10

score 1 · Answer 3 · answered Jan 22 '16 at 04:19

1

I use

SELECT MAX(<IdentityColumn>) FROM <TableName>

answered Jan 22 '16 at 04:19

user5824492

3 Answers3