Monday, December 8, 2008

Random results

This is related to sqlserver.
Our team recently completed a project for a Real estate company, for which we received thank-you letters and e-mails from very happy customers.we have stored this in a table.
we want to show this on page. We chose to display 10 notes, but we didn't want a fixed display because it would be boring and require maintenance. So, we opted to display 10 notes selected at random.

To do this just we have used a simple query which displays
different result at diffent times.

select top 3* from table name order by newid()

No comments: