I'm doing an insert in a CLR stored procedure and I want to return the newly inserted row. Using IDENT_CURRENT doesn't work, but using @@IDENTITY does. I don't feel comfortable using @@IDENTITY as the semantics dictate that it may not return
the intended row. Is IDENT_CURRENT not supported in a CLR SP?
View Complete Post