tag:blogger.com,1999:blog-12467669.post113582258681449242..comments2023-04-29T07:23:25.825-04:00Comments on Jay Fields' Thoughts: Returning an Id from SQL ServerJayhttp://www.blogger.com/profile/14491442812573747680noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-12467669.post-1135853324843525792005-12-29T05:48:00.000-05:002005-12-29T05:48:00.000-05:00I use a final SELECT, but I return SCOPE_IDENTITY(...I use a final SELECT, but I return SCOPE_IDENTITY() instead of @@IDENTITY, because @@IDENTITY can be wrong if you have triggers.Anonymoushttps://www.blogger.com/profile/12586242966886118700noreply@blogger.com