Random Select Columns in MS SQL Database

SELECT example FROM yourtable WHERE yourcondition ORDER BY NEWID()

If you just need some data ,you can try this:

SELECT Top n FROM yourtable WHERE yourcondition ORDER BY NEWID()