if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?
Answer Posted / arunbhararthi
you can use top keyword to fetch the first 20 records from
sql server.Here is the query for that:
for example:
select top20 empname from emp.
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
What is the main function of url routing system in asp.net mvc? : asp.net mvc
How to create a db connection at one place/page so that we can use that connection for all pages/forms/windows.what r the steps ned to be performed if question not clear,let me know
What are the merits and demerits of viewstate?
What is base class of button control in .net?
What is a web api endpoint?
What is request and response in asp.net?
How you can access the properties and controls of master pages from content pages?
Which platform does Microsoft .NET use for exchanging data between applications?
What is session in http request?
What are the versions of garbage collection?
What is Bundling and Minification in MVC?
What are the different types of validation controls provided in ASP.NET?
Define asp.net caching?
benefits of migration from asp to asp.net hi frnds, i have to give presentation to a client about how useful would be migrating their project from asp to asp.net .plz give me some points which i should incorporate in my ppt thanks
What is session state server?