Solved

Select top 1000 * from Loan" (assume default SQL installation) and I notice that it does not come back

Posted on 2011-02-24
6
415 Views
Last Modified: 2012-05-11
When doing...
Select top 1000 * from Loan" (assume default SQL installation) and I notice that it does not come back.
What common solution might I try next to "remedy" the problem?  
And what might be the problem?
0
Comment
Question by:tesla764
6 Comments
 
LVL 26

Expert Comment

by:tigin44
ID: 34971312
can you clarify? what is your problem?
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 34971317
Please explain what you mean by "it does not come back"
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 34971322
Select top 1000 * from Loan"

should give you a syntax error however


Select top 1000 * from Loan

should work but better add a where clause and with (nolock) hint like below:

Select top 1000 * from Loan with(nolock) where loan_date = ......
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:tesla764
ID: 34971437
We are on a highly transactional SQL Server, By not coming back I mean no data is returned after executing the query "Select top 1000 * from a table called Loan"
0
 
LVL 26

Expert Comment

by:tigin44
ID: 34971465

did you check the blocking processes?

issue an sp_who2 command and check the results...
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 34972477
try this : Select top 1000 * from Loan With(nolock)

im assuming your not reciving any error message
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Powershell v3 - SQLCMD 3 26
SQL Quer 4 21
HTML <font style="color:red"> 9 29
job schedule 8 16
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question