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();
----------------------------------------------------------

Thanks in advance

[Nicole Calinoiu]

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

@@IDENTITY:
http://msdn.microsoft.com/library/en...obals_50u1.asp
numeric data type:
http://msdn.microsoft.com/library/en...de-dz_3grn.asp
SQL type mapping:
http://msdn.microsoft.com/library/en...taSqlTypes.asp
SqlDecimal type conversions:
http://msdn.microsoft.com/library/en...atorsTopic.asp
"Micheal" <fr****@sbcglobal.net> wrote in message
news:OB*************@TK2MSFTNGP10.phx.gbl...

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();
----------------------------------------------------------

Thanks in advance