c# tableadapter - get identity on insert - SQL Server CE

  • a.ambron

    Valued Member

    Points: 69

    Hi All

    I'm trying to get the identity of an inserted record from a table in SQL Server CE using a table adapter , but not able to. I tested the same in SQL Server - no problem. Can anyone help? I'm programming in C#.

    Thanks!

  • prem.niet

    Valued Member

    Points: 69

    Hi.. i think for that You need to use

    SCOPE_IDENTITY()

    @@IDENTITY in sql server 2005.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply