Howe to make random top X rows sql

SELECT TOP [Number]  [Field] FROM [TableName]
ORDER BY NEWID()


Read More

How to convert DateTime to Hour / Minute / Second

SELECT
CONVERT(VARCHAR(8) , GETDATE() , 108) AS HourMinuteSecond,
CONVERT(VARCHAR(5) , GETDATE() , 108) AS HourMinute

Read More