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 are HTTP handlers in ASP.NET?
Explain asp.net mvc request life cycle? : asp.net mvc
How use Xml data in ASP.net?
What is the namespace to create thread in .net?
Which protocol is used to call web service?
How do you hide the columns?
How can we inherit a static variable?
How do I open an ashx file?
What is the purpose of session management?
What is syntax code to send email from an asp.net application?
What is the difference between ASP.NET Webforms and ASP.NET MVC?
Explain page output caching?
Take a Large textbox allow to type any data. Task 1:display the count of vowels in a lable on key press event of the textbox Task 2:dispaly count of dates in a lable when dates in following foramats:dd/mm/yy , mm/dd/yy , yy/mm/dd. Task3:compare 2 dates and display both are same or not which dates are in dd/mm/yy and mm/dd/yy farmats.
Why cyclomatic complexity is important?
How does exception management works in ASP.NET?