I believe it is because of the incremental property of the identity
----- Original Message ----- From: Jim Arnold <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 12:41 PM Subject: [DOTNET] Return type of @@IDENTITY > Can anyone explain why SQL Server's @@IDENTITY field is returned as a > System.Decimal from the managed provider, regardless of the column's SQL > type (int in this case)? Or at least can they confirm that it is always > Decimal, and doesn't vary? Smells like laziness in the TDS parser, but I > just wanted a sanity check. > > cheers, > > Jim > > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or > subscribe to other DevelopMentor lists at http://discuss.develop.com. > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
