1. Home
  2. Point-Of-Sale Software
  3. SQL Express Help/Question

SQL Express Help/Question

The time has come to shrink my database. I have done this many times before, but this will be my first time with SQLExpress.

I conenct to the database in the administrator, and type in the following for a query:

select * from journal

It runs for a good 20 minutes...then the results come up and there is nothing there. The headers for all of the journal entries are there, but there is no data and it says "0 row(s) returned"

What am I doing wrong?

Reply to
Lance
Loading thread data ...

select * from journal is a pretty intensive way just to find a count of how much you have there. A better way would be:

select count(id) from journal where time The time has come to shrink my database. I have done this many times before,

Reply to
Matt Hurst

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.