ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ASP.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
if i have 1000 records and i want to access 20 ata time 
from SQL server, what will be the query?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: if i have 1000 records and i want to access 20 ata time from SQL server, what will be the query?
Answer
# 1
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 ?    1 Yes 7 No
Arunbhararthi
 
  Re: if i have 1000 records and i want to access 20 ata time from SQL server, what will be the query?
Answer
# 2
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 ?    2 Yes 6 No
Gowtham
 
 
 
  Re: if i have 1000 records and i want to access 20 ata time from SQL server, what will be the query?
Answer
# 3
Use The following Query for the problem...

Declare @PageIndex int
set @PageIndex=1
Declare @PageSize int
set @PageSize=20
while @PageIndex < 1000
begin
	SELECT * FROM test WHERE ID between
	@PageIndex and @PageIndex+@PageSize-1
  set  @PageIndex = @PageIndex + 20
end
 
Is This Answer Correct ?    6 Yes 2 No
Vijendra Singh
 
  Re: if i have 1000 records and i want to access 20 ata time from SQL server, what will be the query?
Answer
# 4
select top 20 * from table-name
 
Is This Answer Correct ?    1 Yes 1 No
Chinnu
 
  Re: if i have 1000 records and i want to access 20 ata time from SQL server, what will be the query?
Answer
# 5
select top 20 * from tablename order by newid()
 
Is This Answer Correct ?    0 Yes 2 No
Raj
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
About SOAP ? Cognizent2
What are the 4 tenants of SOA/D.  1
How does the browser enable AutoPostBack functionality?  1
How do you a replicate a set of controls across a number of ASP Pages  2
For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this? Microsoft2
If i have a page where i create an instance of a dll and without invoking any method can I send values to next page ? Satyam1
How do you create a permanent cookie?  2
Have you used microsoft dataaccess blocks and Exception blocks? Microsoft1
what if we delete web.config or machine.config? will a website work if we delete webconfig....or if we delete machine config? TCS2
accessing a textbox that was created dynamically? for (int i = 0; i < t1; i++) { TextBox t2 = new TextBox(); t2.ID = "adf" + i; PlaceHolder1.Controls.Add(t2); } accessing data entered in the above created controls.  1
I am having four text boxes in my web application. I am setting Required Field validator to each Text box. And I am having two buttons in my application. If i clicked the first button only first two text box validation will get fire. Dont show error message for remaining two text box. If i clicked second button last two text box validation will get fired. It will not consider the first two validation controls. That is how to enable and disable the validation controls.  4
How do you turn off cookies for one page in your site? IBS2
Which template must you provide, in order to display data in a Repeater control?  1
How can we read a columnised text data in ASP.Net C#? Columnised means my data is stored in a text file and I have numeric data or string data in this file. For ex. If I am searching for the data of gender and I know that gender data is stored at column 32 in text file. How can I get this data in ASP.Net page. Thanks for help in advance.  2
what is CLR? PrimeLine3
Can private assembly be used for more than one application? If so how? Satyam6
What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?  3
What is an Interface and What is an Abstract Class?  3
Where on the Internet would you look for Web services? IBM2
Suppose you want a certain ASP.NET function executed on MouseOver overa certain button. Where do you add an event handler? Visual-Soft3
 
For more ASP.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com