set statistics TIME ON /****** Script for SelectTopNRows command from SSMS ******/ Select * from [AdventureWorks].[Production].[TransactionHistory] WHERE TransactionID = (Select Top 1 [TransactionID] from [AdventureWorks].[Production].[TransactionHistory] Order By NewID() ) SELECT TOP 1 [TransactionID] ,[ProductID] ,[ReferenceOrderID] ,[ReferenceOrderLineID] ,[TransactionDate] ,[TransactionType] ,[Quantity] ,[ActualCost] ,[ModifiedDate] FROM [AdventureWorks].[Production].[TransactionHistory] order by NEWID()