Hi there. On my SQLExpress server, I have several Databases. How do I write a query for a specific Database Table ? I am trying to get the count of the number of records in a table. This is what I have so far, but of course it doesn't work:
SELECT COUNT(RecordID) FROM Settings WHERE RecordID > 0
Settings is the table name, and WebBook is the name of the database. It would seem that I should identify the database at some point.
Thank you for your help.