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

  • 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!

  • Hi.. i think for that You need to use

    SCOPE_IDENTITY()

    @@IDENTITY in sql server 2005.

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

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