|
-
Jul 16th, 2009, 01:02 PM
#1
Thread Starter
Frenzied Member
Insert and Update in one storedprocedure
I have a storedprocedure that I put the INsert and Update together in one store procedure. On my varaibles, I declared an @ID as integer
But my ID in my db is Autoincremented, now my problem is that whenever I tried to insert something, it complains that the ID doesn't supply. But during the insert, I don't need to insert the ID because it's auto increment, but I need the ID for the Update... how do I do this?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|