Why does select SCOPE_IDENTITY() return a decimal instead of an integer?

by

In SQL Server, the IDENTITY property can be assigned to tinyint, smallint, int, bigint, decimal(p, 0), or numeric(p, 0) columns. Therefore the SCOPE_IDENTITY function has to return a data type that can encompass all of the above.

As previous answers have said, just cast it to int on the server before returning it, then ADO.NET will detect its type as you expect.

More Related Contents:

  1. What are the best practices for using a GUID as a primary key, specifically regarding performance? [closed]
  2. SQL Server add auto increment primary key to existing table
  3. How to choose the clustered index in SQL Server?
  4. Local and global temporary tables in SQL Server
  5. Get first day of week in SQL Server
  6. What is the significance of 1/1/1753 in SQL Server?
  7. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  8. How to delete large data of table in SQL without log?
  9. Insert Update trigger how to determine if insert or update
  10. SQL Server: UPDATE a table by using ORDER BY
  11. EF5: Cannot attach the file ‘{0}’ as database ‘{1}’
  12. Do I really need to use “SET XACT_ABORT ON”?
  13. What is a Trusted Connection?
  14. SQL Server: How to select all days in a date range even if no data exists for some days
  15. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  16. Do while loop in SQL Server 2008
  17. TSQL: How to convert local time to UTC? (SQL Server 2008)
  18. Connecting to MS SQL Server with Windows Authentication using Python?
  19. Using COALESCE function to make values separated with commas
  20. How to programmatically create an ODBC Linked Table to a SQL Server View and have it be editable?
  21. Assign result of dynamic sql to variable
  22. How do I create a multiple-table check constraint?
  23. Stored Procedure and Permissions – Is EXECUTE enough?
  24. Best way to store time (hh:mm) in a database
  25. Stored procedure – return identity as output parameter or scalar
  26. SQL Server Group by Count of DateTime Per Hour?
  27. How to import a DBF file in SQL Server
  28. Why does a parameterized query produces vastly slower query plan vs non-parameterized query
  29. SQL Server: Filter output of sp_who2
  30. How can I insert binary file data into a binary SQL field using a simple insert statement?

Leave a Comment