if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?

Answer Posted / raj

select top 20 * from tablename order by newid()

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is masterpage?

518


What is Dynamic Web and discuss its usage with the help of real life examples?

608


What is base class of .net?

546


In your ASP.NET 2.0 web application you want to display an image that is selected from a collection of images. What approach will you use to implementing this?

573


If 200 is for all successful operation then why do we have 201 response codes?

538






how to retrieve property settings from xml .config file.

557


What are the events in a page life cycle?

543


Explain model, view and controller represent in an mvc application? : asp.net mvc

521


Can a master page have more than one contentplaceholder?

518


What is postback request?

564


What is the use of global.asax file?

561


What is the request flow used for asp.net mvc framework? : asp.net mvc

541


How can we prepairing Interview

1900


How long should a session id be?

538


If there are multiple update panels on the page say upd1 and upd2. There is a button placed in upd1. How can you stop upd2 to update when button placed in upd1 is clicked?

579