SQL Server @@IDENTITY Problem

[SStory]

I believe the better way is to place this in a stored procedure and return
the identity property. It will work like that.
Return it in an output parameter or a select statement if you prefer execute
scalar or you might even return it as a return value

Return values and output params take a little more work--I know...

HTH
Shane

"Micheal" <frooyo@sbcglobal.net> wrote in message
news:OY0tdKrVDHA.2288@TK2MSFTNGP12.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
>
>

[Greg Low \(MVP\)]

Absolutely. Also consider using SCOPE_IDENTITY with SS 2000 as it avoids
problems where triggers have been assigned.

HTH

--
Greg Low (MVP)
MSDE Manager SQL Tools
[url]www.whitebearconsulting.com[/url]

"SStory >" <Shane_Story@online.msn.com <remove the 'online.' to send me
mail> wrote in message news:%23x6ki2sVDHA.1620@TK2MSFTNGP12.phx.gbl...

> I believe the better way is to place this in a stored procedure and return
> the identity property. It will work like that.
> Return it in an output parameter or a select statement if you prefer

execute

> scalar or you might even return it as a return value
>
> Return values and output params take a little more work--I know...
>
> HTH
> Shane
>
> "Micheal" <frooyo@sbcglobal.net> wrote in message
> news:OY0tdKrVDHA.2288@TK2MSFTNGP12.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
> >
> >

>
>