;with cte as( select top 1 * from tb order by id desc ) update cte set col='hello,world'
sql中没有vfp的记录号的概念吗?
DECLARE @con INT SELECT @con=COUNT(*) FROM sysobjects DECLARE @rowcount INT SET @rowcount=10 --最后10條 SELECT TOP (@rowcount) * FROM sysobjects WHERE ID NOT IN(SELECT TOP (@con-@rowcount) ID FROM sysobjects )這樣用
DECLARE @con INT SELECT @con=COUNT(*) FROM sysobjects DECLARE @rowcount INT SET @rowcount=1 --最后1條 SELECT TOP (@rowcount) * FROM sysobjects WHERE ID NOT IN(SELECT TOP (@con-@rowcount) ID FROM sysobjects 最后一條,以唯一列判斷,不改變表的順序
;with cte as(
select top 1 * from tb order by id desc
)
update cte set col='hello,world'
SELECT @con=COUNT(*) FROM sysobjects DECLARE @rowcount INT
SET @rowcount=10 --最后10條
SELECT TOP (@rowcount) * FROM sysobjects WHERE ID NOT IN(SELECT TOP (@con-@rowcount) ID FROM sysobjects )這樣用
SELECT @con=COUNT(*) FROM sysobjects DECLARE @rowcount INT
SET @rowcount=1 --最后1條
SELECT TOP (@rowcount) * FROM sysobjects WHERE ID NOT IN(SELECT TOP (@con-@rowcount) ID FROM sysobjects 最后一條,以唯一列判斷,不改變表的順序