Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

5
  • Thanks, Mark. The value I am trying to return is "ID" if the row, auto generated, primary key, selected after the new row is inserted using SCOPE_IDENTITY(). Column is not set to accept null as you can understand, being primary key. but result may be null if operation is not successfully ?? Commented Dec 4, 2009 at 23:37
  • Primary keys should not usually be nullable. Typically if an insertion fails you will get an exception, not a null, although this does of course depend on what API you are using. Commented Dec 4, 2009 at 23:38
  • It is not nullable, But returning result from stored proc could be. Commented Dec 4, 2009 at 23:43
  • Then either that's an error in the stored procedure and you should fix it, or probably the stored precodure returns null in order to tell you that an error occurred, and you should first check for null and handle that error before you try to make the cast. If you don't do this, you will get an exception when you try to cast to int. Commented Dec 4, 2009 at 23:48
  • A minor correction to my previous post - I hope the meaning was clear before, but just to clarify: If you don't do this, and the stored procedure returns null, you will get an exception when you try to cast to int. Commented Dec 5, 2009 at 0:26