ExecuteScalar return decimal instead of int?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RA - 03 Mar 2004 23:59 GMT

Hi

When I use the ExecuteScalar and the sql looks like this "Insert ...; Select
SCOPE_IDENTITY()" I get the return value as decimal - how can I cast it so
it will return an integer? I use .net c#

Thanks

Reply to this Message

Wolly - 04 Mar 2004 08:46 GMT

int value = int.Parse( cmd.ExecuteScalar(...) )

bye

Reply to this Message

Miha Markic [MVP C#] - 04 Mar 2004 09:01 GMT

or Convert.ToInt32(..)

Signature

Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

> Hi
>
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

RA - 04 Mar 2004 14:18 GMT

But is there a way in the sql statement forcing it to return integer? The
identity value in the db is defined as int.
Maybe "select SCOPE_IDENTITY () as integer" ? I am not sure about the
syntex. By the way is this the best way to get the new added row identity
column to the database?

Thanks

> or Convert.ToInt32(..)
>
[quoted text clipped - 11 lines]
> >
> > Thanks

Reply to this Message

Miha Markic [MVP C#] - 05 Mar 2004 08:43 GMT

Hi,

Well, yes, it doesn't really matter where you do the conversion.
select cast(scope_identity() as int) will do it on the server (note that
identity can go over int).

And yes, this is the best and correct way to retrieve the last inserted
identity field in the current transaction.

Signature

Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

> But is there a way in the sql statement forcing it to return integer? The
> identity value in the db is defined as int.
[quoted text clipped - 20 lines]
> > >
> > > Thanks

Reply to this Message

ExecuteScalar return decimal instead of int?

Free Magazines