How to get previous and next row's value effeciently in SQL server

SELECT P.PreviousID, N.NextID
FROM
(SELECT  MAX(D.AssetID) PreviousID
FROM Asset D
WHERE AssetID<@AssetID) P
CROSS JOIN
(SELECT  MIN(D.AssetID) NextID
FROM Asset D
WHERE AssetID>@AssetID) N