sql中 怎么查询表中的最后一条记录

select top1 * from b where order by id desc

搞定

有问题请发站内信！

ok

选中B表中最后一条记录的方法：
select top (select count(*) from B) *
from B
except
select top ((select count(*) from B)-1) *
from B
不过问题是，B表中最后一条记录并不一定是你刚才插入的那一条。因为如果B表中存在主键的话，每插入一条记录，B表都会按照主键重新进行排序。

select max(id) from 表

create trigger [ican005] on [dispatchlists]
for insert
as

declare @dlid varchar (50)
declare @ccuscode varchar (100)
declare @cinvcode varchar (100)
declare @runs int
declare @okE int
declare @autoid varchar(50)

set @runs=0
set @okE=0

if update(iquantity)
begin
if (select cstcode from dispatchlist a inner join inserted b on a.dlid=b.dlid)<>'03'
begin
set @dlid=(select dlid from inserted)
set @ccuscode=(select c.ccusabbname from dispatchlist t inner join inserted ind on t.dlid=ind.dlid left join customer c on c.ccuscode=