Tuesday, February 21, 2012

SCOPE_IDENTITY()

is there an sql mobile equivalent of SCOPE_IDENTITY()?

SQL Mobile does support @.@.IDENTITY but there is no need for the concept of scope because there is no support for sprocs, triggers, etc so this distinction is meaningless.

Darren

|||

hello,

I would like to know how come I did try and I did not work for me

What I did was literary from the SQL Server Editor in Visual Studio type select @.@.Identity and it did not work for me

Thanks in advance

|||

Hello Nelson,

Execute that command on Pocket PC's Query Analyzer. It works.

Greetings.

No comments:

Post a Comment