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
15345 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 is viewstate information stored?

1135

What is Web Server Control Templates.?

1110

What are the types of validation in asp net?

1087

What is application variable in asp.net?

977

What are the differences between code behind and code inline?

1177

What are sessions used for?

1051

Can I stream live content/events?

1117

What are the differnt types of handler in ASP.NET?

1025

What is the compiled object?

2133

What is difference between web api and web services?

1055

what is the difference between response.write() and response.output.write()?

1217

What is the difference between client-side and server-side validations in ASP.NET?

1233

Which method is used to force all the validation controls to run?

1077

What are the built-in objects in asp.net?

1039

Can you explain one critical mapping? Performance issue which one is better?

950