How do I cast Scope_Identity() to Int?

Question

So Scope_Identity() returns an ?-Byte Numeric Type in SQL Server.

That is not awesome.

Is there a safe way to cast it to an int in a select query so we don't have to manage every whim of SQL Server in our ODBC Wrapper?

Answer 1

SELECT CAST( bigintcolumn AS int )

(Provided you know it will fit into a 32bit integer)

Answer 2

Just cast this like:

select CAST(SCOPE_IDENTITY() as int)

And your data Layer:

reader.GetInt32(0);