SELECT * FROM (SELECT [UserId],[UserBalance],[TotalAmount],[MissionAmount],[ToCardAmount],[UserGoldCoinBalance],[TotalGoldCoinAmount],[CreditScore],[CreatedAt],[CreatedUserId],[UpdatedAt],[UpdatedUserId],ROW_NUMBER() OVER(ORDER BY GETDATE() ) AS RowIndex FROM [UserAccount] WITH(NOLOCK) WHERE ( [UserId] = @UserId0 )) T WHERE RowIndex BETWEEN 1 AND 1
uj5u.com熱心網友回復：
取隨機記錄？UserId應該有索引的吧
SELECT TOP(1) [UserId],
[UserBalance],
[TotalAmount],
[MissionAmount],
[ToCardAmount],
[UserGoldCoinBalance],
[TotalGoldCoinAmount],
[CreditScore],
[CreatedAt],
[CreatedUserId],
[UpdatedAt],
[UpdatedUserId],
NEWID() AS RowIndex
FROM [UserAccount] WITH(NOLOCK)
WHERE ([UserId] = @UserId0)
ORDER BY RowIndex;
uj5u.com熱心網友回復：
非常感謝版主的及時回復，目前已處理，特別感謝！uj5u.com熱心網友回復：
為什么要ORDER BY GETDATE() 呢，不直接order by userIduj5u.com熱心網友回復：
-- UserId 是主鍵，只可能取一條記錄出來，不需要那么多限制，越簡單越好。
SELECT [UserId],
[UserBalance],
[TotalAmount],
[MissionAmount],
[ToCardAmount],
[UserGoldCoinBalance],
[TotalGoldCoinAmount],
[CreditScore],
[CreatedAt],
[CreatedUserId],
[UpdatedAt],
[UpdatedUserId]
FROM [UserAccount] WITH(NOLOCK)
WHERE [UserId] = @UserId
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/11392.html
標籤：應用實例
上一篇：級聯洗掉和洗掉觸發器的區別
下一篇：SQL中如何回圈計算