How to get current identity number of specific table in sql server compact

sql sql-server-ce
Hamid picture Hamid · Jul 9, 2013 · Viewed 42.8k times · Source

I want to get current identity value of a specific table Like IDENT_CURRENT('table') in sql server

Answer

Samba picture Samba · Oct 20, 2016

If you want to get a last identity inserted value for a particular table use the following statement:

select IDENT_CURRENT('tablename')

For example:

select IDENT_CURRENT('Employee')

Related questions

How to connect to SQL Server from another computer?

I want to connect from home using SQL Server 2005 to another PC. I had a look on the msd...but before connecting it says I should connect to another computer using the computer management and it didn't work out....I …

Read More
SQL: Return only first occurrence

I seldomly use SQL and I cannot find anything similar in my archive so I'm asking this simple query question: I need a query which one returns personID and only the first seenTime Records: seenID | personID | seenTime 108 3 13:34 109 2 13:56 110 3 14:22 111 3 14:31 112 4 15:04 113 2 15:52 Wanted result: personID | …

Read More
Insert into one column by selecting another column in other table but how fill the second column

i have a table which has two columns i'd fill one of the columns by selecting other table column data but how can i fill the next column cause i can't use VALUE. Here's the code INSERT INTO Numbers(number, …

Read More