So I have a table with an identity column as the pri开发者_如何学运维mary key, so it is an integer. So, why does SCOPE_IDENTITY() always return a decimal value instead of an int to my C# application?
Started getting this error it seems since we upgraded to SQL Server 2008. When inserting into the db and then returning the identity i get a \'Item cannot be found in the collection corresponding to