• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 458
  • Last Modified:

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

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
tesla764
Asked:
tesla764
1 Solution
 
tigin44Commented:
can you clarify? what is your problem?
0
 
Patrick MatthewsCommented:
Please explain what you mean by "it does not come back"
0
 
lcohanDatabase AnalystCommented:
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
tesla764Author Commented:
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
 
tigin44Commented:

did you check the blocking processes?

issue an sp_who2 command and check the results...
0
 
Aaron ShiloChief Database ArchitectCommented:
try this : Select top 1000 * from Loan With(nolock)

im assuming your not reciving any error message
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now