SQL Server @@identity Problem

[Micheal]

The below code does _not_ work! The datatype for the autoincrement value is
INT in SQL Server 2000. The strange thing is that if I use a 'decimal' it
works (using .NET framework 1.1)

---------------------------------------------------------
string sql = "insert into sports (name) value ('test'); select @@identity";

conn.Open();

SqlCommand cmd = new SqlCommand(sql, conn);
int result = (int)cmd.ExecuteScalar();

 

[Nicole Calinoiu]

This is an expected type conversion error. For details, see:

@@IDENTITY:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_globals_50u1.asp
numeric data type:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_de-dz_3grn.asp
SQL type mapping:
http://msdn.microsoft.com/library/en-us/cpref/html/frlrfSystemDataSqlTypes.asp
SqlDecimal type conversions:
http://msdn.microsoft.com/library/e...ystemDataSqlTypesSqlDecimalOperatorsTopic.asp