I have an SP in SQL Server 2000 that returns an Identity. I want to display the Identity to the user via a message box in my Access Data Project (ADP).
My SP looks like this:
Create Procedure uspMySp
@AssetName char (10), @AssetTown char (10)
INSERT INTO tblMyTable
MyTable contains 3 fields (@AssetCode, @AssetName, @AssetTown)
How would you execute the SP and provide the user with the @@Identity via a message box? I do not know how to use parameters...so if that is the way forward I could do with an example.
Many thanks, Simon