在SQL中检索最后插入的记录 [英] Retreive last inserted record in sql

问题描述

我需要一个查询，通过该查询我可以知道，当我在表中插入一条记录时，假设我在表中插入了5条记录，那么我可以检索到同一条记录，该如何在sql server 2005中实现呢? class ="h2_lin">解决方案

我仅次于解决方案1.
这是类似于问题及其解决方案的链接

我想要对最近25行进行sql查询 [ SELECT TOP ( 1 )* FROM TABLENAME ORDER BY sNO DESC

希望对您有帮助. :)

解决方案

I second what Solution 1 was.
Here is link which is similar to question and its solution

I want a sql query for latest 25 rows[^]

Add One More Column To Your SQL Table sNO With DataType Numeric(18,0) And Identity Specification Yes. If Your Table Already Contain Column Like this then Use this Column insted of sNO Then Use Following SQL Query :

SELECT TOP(1) * FROM TABLENAME ORDER BY sNO DESC

I hope it will help you. :)

This link can help you

http://blog.sqlauthority.com/2007/10/01/sql-server-2005-output-clause-example-and-explanation-with-insert-update-delete/

这篇关于在SQL中检索最后插入的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！