you can also use Set Rowcount keyword to fetch the records from sql serve

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

Question Posted / gowtham

9 Answers
14629 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / gowtham

you can also use Set Rowcount keyword to fetch the records
from sql server.Here is the query for that:

Set Rowcount 20
Select Empname from emp
Set RowCount 0

Is This Answer Correct ?

6 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are strong names?

978

What is the web.config file in asp?

1097

About CLR, reflection and assemblies?

1913

List of words of preprocessor in .net?

889

hi .net gurus. plz if any one has dumps on 70-631 and 70-541 on windows sharepoint services kindly mail me.

1609

Can I combine classic asp and asp.net pages?

978

What types of data validation events are commonly seen in the client-side form validation?

931

Explain the main differences between asp and asp.net?

965

What do you understand from custom control?

1058

What is the difference between system.stringbuilder and system.string

711

Explain exception filters?

976

What is the purpose of using MVC programming pattern in ASP.NET?

990

What is the adavantage of using ASP.NET routing?

1107

Describe Segmentation With Paging?

1012

Describe how to implement globalization and localization in the use interface in .net.

903