返回首页

大家好,

我需要得到我的表中的最后inseted ID。如何做到这一点。请帮助

回答

评论会员:游客 时间:2012/02/07
爱德华・卢:尝试下面的代码:codeprelang="SQL"spanclass="code-keyword"SELECT/spanMAX(id)spanclass="code-keyword"FROM/span[tablename]/pre/code或{C}或codeprelang="SQL"spanclass="code-comment"--/spanspanclass="code-comment"INSERTSTATEMENTHERE/spanspanclass="code-keyword"SELECT/spanspanclass="code-preprocessor"@@IDENTITY/span/pre/code的问候,爱德华
coded007
评论会员:游客 时间:2012/02/07
写查询codeprelang="SQL"spanclass="code-keyword"select/spanspanclass="code-keyword"top/spanspanclass="code-digit"1/spanidspanclass="code-keyword"from/spantable_namespanclass="code-keyword"order/spanspanclass="code-keyword"by/spanidspanclass="code-keyword"desc/span/pre/code