Back to discussion

@@IDENTITY

Last post was 30 Jul 2003 at 00:05
sql server United States
  • 17 years ago

    Consider Table A with an Identity field.


    What I need is to enter this autogenerated number in another field within the same table.
    ie. my table may have two field with the same value(IDENTITY). Actually the field value is conditionally set. But at times, it might have the value of the @@IDENTITY. I need it to reflect a self-join situation.


    eugene

    Report abuse

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

SQL Server forum discussion

SQL Server tutorials

Quick links

Recent activity

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“If Java had true garbage collection, most programs would delete themselves upon execution.” - Robert Sewell