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

Hamid

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

Hamid
SELECT AUTOINC_SEED 
FROM INFORMATION_SCHEMA.COLUMNS 
where TABLE_NAME='tablename' 
and COLUMN_NAME='columnName'

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

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

From Dev

Changes do not get saved permanently into SQL Server Compact edition

From Dev

Know if specific column is identity (in SQL Server)

From Dev

Get the current month number in SQL Server, 1 for january, 12 for december

From Dev

SQL Server inserting huge number of rows to a table with default values and identity column in it

From Dev

How to get the next identity value from SQL Server

From Dev

How to get and lock next identity value SQL Server

From Dev

SQL Server : get the row Identity

From Dev

Use SQL Server Compact with ASP.NET Identity

From Dev

How to get Identity value from SQL server after insert record

From Dev

SQL Server How to insert current results into table

From Dev

IDENTITY_INSERT and SQL Server Compact

From Dev

Auto increment of identity to a specific number in Sql server

From Dev

Get number of rows in a SQL Server table in VB.NET

From Dev

Changes do not get saved permanently into SQL Server Compact edition

From Dev

Get the current month number in SQL Server, 1 for january, 12 for december

From Dev

How do I get 'n' number of rows of dates preceded by current date in SQL Server?

From Dev

How to get @@identity in Visual Studio 2012 using SQL Server 2008

From Dev

How to get the Current Year to Current date in sql server 2008

From Dev

connecting to sql server compact

From Dev

SQL Server : get the row Identity

From Dev

Use SQL Server Compact with ASP.NET Identity

From Dev

How to get the count of a join table in sql server?

From Dev

How to get elements from table by row number in sql server

From Dev

How to get a combined/merged table in sql server?

From Dev

How do I populate my Date Dimension Table in SQL Server so as to get a column with this specific value?

From Dev

Store in a variable the number of rows from a table where a column has a certain value in SQL Server Compact

From Dev

How to get sum of specific column at specific row range in SQL Server?

From Dev

ng-table - how do I get the current page number

Related Related

  1. 1

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

  2. 2

    Changes do not get saved permanently into SQL Server Compact edition

  3. 3

    Know if specific column is identity (in SQL Server)

  4. 4

    Get the current month number in SQL Server, 1 for january, 12 for december

  5. 5

    SQL Server inserting huge number of rows to a table with default values and identity column in it

  6. 6

    How to get the next identity value from SQL Server

  7. 7

    How to get and lock next identity value SQL Server

  8. 8

    SQL Server : get the row Identity

  9. 9

    Use SQL Server Compact with ASP.NET Identity

  10. 10

    How to get Identity value from SQL server after insert record

  11. 11

    SQL Server How to insert current results into table

  12. 12

    IDENTITY_INSERT and SQL Server Compact

  13. 13

    Auto increment of identity to a specific number in Sql server

  14. 14

    Get number of rows in a SQL Server table in VB.NET

  15. 15

    Changes do not get saved permanently into SQL Server Compact edition

  16. 16

    Get the current month number in SQL Server, 1 for january, 12 for december

  17. 17

    How do I get 'n' number of rows of dates preceded by current date in SQL Server?

  18. 18

    How to get @@identity in Visual Studio 2012 using SQL Server 2008

  19. 19

    How to get the Current Year to Current date in sql server 2008

  20. 20

    connecting to sql server compact

  21. 21

    SQL Server : get the row Identity

  22. 22

    Use SQL Server Compact with ASP.NET Identity

  23. 23

    How to get the count of a join table in sql server?

  24. 24

    How to get elements from table by row number in sql server

  25. 25

    How to get a combined/merged table in sql server?

  26. 26

    How do I populate my Date Dimension Table in SQL Server so as to get a column with this specific value?

  27. 27

    Store in a variable the number of rows from a table where a column has a certain value in SQL Server Compact

  28. 28

    How to get sum of specific column at specific row range in SQL Server?

  29. 29

    ng-table - how do I get the current page number

HotTag

Archive