No Lock SQL query sample

 This sql query shows the records that are stored in SQL table buffer between the ttsbegin and ttscommit. In case, if there is failure to insert record into table. we can know what record was present before the failure

select REPLENISHMENTORDERNUMBER, * from ConsignmentDraftReplenishmentOrderJournalLine with (nolock) order by recid desc

Query to select last 10 records

  select TOP 10 itemid, QTY, INVENTTRANSORIGIN, INVENTDIMID, * from INVENTTRANS with (nolock) order by recid desc