What happens if I Select SCOPE_IDENTITY() after an insert fails ...

2009年3月20日 - The MSDN docs weren't entirely clear on this one. or perhaps I'm not ... If no Identity is inserted SCOPE_IDENTITY() will return null, you can ...

stackoverflow.com